{"id":241,"date":"2022-08-22T03:37:35","date_gmt":"2022-08-22T00:37:35","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=241"},"modified":"2023-05-13T06:21:04","modified_gmt":"2023-05-13T03:21:04","slug":"programavimas-naudojant-vba-ms-excel-aplinkoje","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=241","title":{"rendered":"Programavimas su Visual Basic for Applications (VBA) MS Excel aplinkoje"},"content":{"rendered":"\n<p style=\"font-style:normal;font-weight:300\">| Kurs\u0173 trukm\u0117: 25 akad. val.<\/p>\n\n\n\n<p style=\"font-style:normal;font-weight:300\">| Kurs\u0173 kaina: 400 Eur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Trumpas kurso apra\u0161ymas<\/h2>\n\n\n\n<p>Kursas skirtas daug dirbantiems MS Excel programa, atliekantiems daug rutinini\u0173 u\u017eduo\u010di\u0173 ir norintiems automatizuoti savo darb\u0105. Mokym\u0173 metu i\u0161moksite ne tik \u012fra\u0161yti MS Excel makrokomandas ir jomis naudotis, bet ir VBA pagalba gal\u0117site jas pakoreguoti. Naudodami VBA proced\u016bras i\u0161moksite kurti ataskaitas, algalapius, nura\u0161ymus ir t. t.<\/p>\n\n\n\n<p>Taupydami laik\u0105 jau sukurtomis valdymo formomis gal\u0117site naudotis ne tik j\u016bs, bet ir j\u016bs\u0173 kolegos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reikalavimai kurso klausytojams<\/h2>\n\n\n\n<p>Mok\u0117ti dirbti MS Excel programa.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kurso programa<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">VBA redaktorius:<\/h4>\n\n\n\n<p>VBA redaktoriaus strukt\u016bra:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Project Explorer;<\/li>\n\n\n\n<li>Properties Window;<\/li>\n\n\n\n<li>Work Area;<\/li>\n\n\n\n<li>Code Module;<\/li>\n\n\n\n<li>Object Browser.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Funkcij\u0173 ir proced\u016br\u0173 vykdymas redaktoriuje.<\/h4>\n\n\n\n<p>Kintamieji:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kintam\u0173j\u0173 tipai;<\/li>\n\n\n\n<li>Deklaravimas;<\/li>\n\n\n\n<li>Kintam\u0173j\u0173 panaudojimas.<\/li>\n<\/ul>\n\n\n\n<p>Programavimo prad\u017eiamokslis:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u0105lyginis sakinys (IF);<\/li>\n\n\n\n<li>Ciklai (For, While);<\/li>\n\n\n\n<li>Bendravimo su vartotoju priemon\u0117s (Msgbox, Input Method).<\/li>\n<\/ul>\n\n\n\n<p>Proced\u016bros:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Proced\u016br\u0173 tipai;<\/li>\n\n\n\n<li>Paprast\u0173 proced\u016br\u0173 k\u016brimas ir vykdymas;<\/li>\n\n\n\n<li>Praktinis darbas su proced\u016bromis;<\/li>\n<\/ul>\n\n\n\n<p>Vartotojo funkcijos (User Defined Function):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Funkcij\u0173 tipai;<\/li>\n\n\n\n<li>Funkcij\u0173 k\u016brimas;<\/li>\n\n\n\n<li>Funkcij\u0173 panaudojimas;<\/li>\n\n\n\n<li>Praktinis darbas su funkcijomis.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Excel objektai ir \u012fvykiai (Excel Objects and Events):<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel bylos objektai ir \u012fvykiai (Workbook Objects and Events);<\/li>\n\n\n\n<li>Darbo lapo objektai ir \u012fvykiai (Worksheet Objects and Events);<\/li>\n\n\n\n<li>Srities objektai ir \u012fvykiai (Range Objects and Events);<\/li>\n\n\n\n<li>Proced\u016br\u0173 objektai (Objects In a Procedure).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Nestandartin\u0117s formos (Custom Forms):<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Form\u0173 k\u016brimas ir valdymas;<\/li>\n\n\n\n<li>Formos savyb\u0117s (Form Properties);<\/li>\n\n\n\n<li>Objekt\u0173 \u012fterpimas formose;<\/li>\n\n\n\n<li>Form\u0173 vykdymas;<\/li>\n\n\n\n<li>Praktinis darbas su formomis.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Projekto k\u016brimas panaudojant VBA.<\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><a href=\"https:\/\/kompiuteriu-kursai.lt\/?page_id=165\"><strong>Artimiausia mokym\u0173 data ir registracija \u279d<\/strong><\/a><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>| Kurs\u0173 trukm\u0117: 25 akad. val. | Kurs\u0173 kaina: 400 Eur. Trumpas kurso apra\u0161ymas Kursas skirtas daug dirbantiems MS Excel programa, atliekantiems daug rutinini\u0173 u\u017eduo\u010di\u0173 ir norintiems automatizuoti savo darb\u0105. Mokym\u0173 metu i\u0161moksite ne tik \u012fra\u0161yti MS Excel makrokomandas ir jomis naudotis, bet ir VBA pagalba gal\u0117site jas pakoreguoti. Naudodami VBA proced\u016bras i\u0161moksite kurti ataskaitas, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[201,203,179,198,197,200,199,202,204,196],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-kursai","tag-darbo-automatizavimas","tag-formu-kurimas","tag-makrokomandos","tag-microsoft-excel","tag-ms-excel","tag-ms-excel-kursai","tag-ms-excel-mokymai","tag-programavimas","tag-vartotojo-funkcijos","tag-visual-basic-for-applications"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=241"}],"version-history":[{"count":10,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":3490,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions\/3490"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}