ã¯ããã«
è¿å¹Žãæ¥åå¹çåã®ããã®ããŒã«ãšããŠãVBAã泚ç®ãããŠããŸããããããVBAãšã¯äžäœäœãªã®ããã©ã®ãããªããšãã§ããã®ããå€ãã®äººã ããŸã ãã®å šè²ãææ¡ããŠããªãã®ãäºå®ã§ãã
VBAã®é åãšã¯
VBAïŒVisual Basic for ApplicationsïŒã¯ãMicrosoft Officeã®äžéšãšããŠæäŸãããããã°ã©ãã³ã°èšèªã§ããExcelãWordãªã©ã®æ¥åžžçãªæ¥åãå¹çåããããã®ããŒã«ãšããŠãå€ãã®ããžãã¹ããŒãœã³ãåŠçã«å©çšãããŠããŸããVBAã®æ倧ã®é åã¯ãã«ã¹ã¿ãã€ãºæ§ã«ãããŸããæšæºã®æ©èœã ãã§ã¯å®çŸãé£ããæ¥åããVBAãçšããããšã§ç°¡åã«èªååããããšãã§ããŸãã
äŸãã°ãæ¯æã®å£²äžå ±åãæåã§äœæããŠãããšããŸãããããVBAã䜿çšããŠèªååããããšã§ãæéãå€§å¹ ã«ç¯çŽããããšãã§ããŸãããŸãããã¥ãŒãã³ãšã©ãŒã®ãªã¹ã¯ãäœæžãããããæ£ç¢ºãªå ±åãè¿ éã«æäŸããããšãå¯èœãšãªããŸãã
ãã®èšäºã®ç®ç
ãã®èšäºã®ç®çã¯ãVBAã®åºæ¬çãªæŠå¿µãæ©èœããããããã解説ããVBAã®é åãå¯èœæ§ãåºãäŒããããšã§ããç¹ã«ãããã°ã©ãã³ã°ã«éŠŽæã¿ã®ãªãæ¹ããVBAãããããåŠã³ãããšèããŠããæ¹ã«åããŠãå ·äœçãªå¿çšäŸãå®è·µçãªãã³ããæäŸããŸãã
ãŸãããã®èšäºãéããŠãVBAã®åŠç¿ã®ç¬¬äžæ©ãšããŠã®ã¢ãããŒã·ã§ã³ãé«ããVBAã掻çšããæ¥åå¹çåã®åãçµã¿ãå§ãããã£ãããšãªãããšãé¡ã£ãŠããŸãã
VBAãšã¯äœãïŒ
ã³ã³ãã¥ãŒã¿ã®äžçã«ã¯å€ãã®ããã°ã©ãã³ã°èšèªãååšããŸããããã®äžã§ãVBAã¯ç¹ã«ããžãã¹ã®çŸå Žã§ã®å©çšãå€ãèšèªã®äžã€ã§ããããããVBAãšã¯å ·äœçã«äœãªã®ããã©ã®ãããªç¹åŸŽãæ©èœãæã£ãŠããã®ããç解ããããšã¯ãVBAã®ç䟡ãåŒãåºãããã®ç¬¬äžæ©ãšãªããŸãã
VBAã®å®çŸ©
VBAïŒVisual Basic for ApplicationsïŒã¯ãMicrosoft Office補åãç¹ã«ExcelãWordãäžå¿ã«çµã¿èŸŒãŸããŠããããã°ã©ãã³ã°èšèªã§ãããã®èšèªã䜿çšããããšã§ãOffice補åã®æšæºæ©èœãè¶ ããã«ã¹ã¿ãã€ãºãèªååãå®çŸããããšãã§ããŸãã
äŸãã°ãExcelã§ç¹°ãè¿ãè¡ãäœæ¥ãè€éãªèšç®ããVBAã®ãã¯ããšããŠèšè¿°ããããšã§ããã¿ã³äžã€ã§ç¬æã«å®è¡ããããšãå¯èœãšãªããŸããããã«ãããäœæ¥ã®å¹çåããã¥ãŒãã³ãšã©ãŒã®åæžãæåŸ ã§ããŸãã
ãã¯ããšã®é¢ä¿
ãã¯ããšã¯ãäžé£ã®äœæ¥ãèªååããããã®ã¹ã¯ãªãããã³ãŒãã®ããšãæããŸããVBAã¯ããã®ãã¯ããäœæã»å®è¡ããããã®èšèªãšããŠæäŸãããŠããŸããå ·äœçã«ã¯ãExcelãWordã®ããã¯ãã®èšé²ãæ©èœã䜿çšããŠããŠãŒã¶ãŒã®æäœãèªåçã«ã³ãŒããšããŠèšé²ããããšãã§ããŸãã
ãã®èšé²ãããã³ãŒãã¯ãVBAãšããŠä¿åãããåŸããäœåºŠã§ãåçããããšãã§ããŸãããŸãããã®ã³ãŒããçŽæ¥ç·šéããããšã§ãããè€éãªåŠçãæ¡ä»¶åå²ãªã©ã®ããã°ã©ãã³ã°çãªèŠçŽ ãè¿œå ããããšãå¯èœã§ãã
äŸãšããŠãæ¯æã®çµŠäžèšç®ã売äžéèšãªã©ãå®åçãªäœæ¥ãèªååããããã®ãã¯ããVBAã§äœæããããšãèããããŸããããã«ãããäœæ¥æéã®ççž®ãããŒã¿ã®æ£ç¢ºæ§åäžãæåŸ ã§ããŸãã
VBAã®äž»èŠãªæ©èœ
å€ãã®äººã ãVBAãå©çšããçç±ã¯ããã®åŒ·åãªæ©èœãšæè»æ§ã«ãããŸããVBAã䜿çšããããšã§ãæ¥åžžã®æ¥åãå€§å¹ ã«å¹çåããããšãå¯èœãšãªããŸãã以äžã§ã¯ãVBAã®äž»èŠãªæ©èœã«ã€ããŠè©³ãã解説ããŠãããŸãã
èªååã®å
VBAã®æãé åçãªæ©èœã®äžã€ããæ¥åã®èªååã§ããäŸãã°ãæ¯æ¥ã®ããŒã¿å ¥åãéèšãã¬ããŒãäœæãªã©ã®ç¹éãªäœæ¥ããVBAã®ãã¯ãã䜿çšããŠèªååããããšãã§ããŸããããã«ãããäœæ¥æéã®ççž®ããã¥ãŒãã³ãšã©ãŒã®åæžããããŠæ¥åã®å質åäžãæåŸ ã§ããŸãã
ãŸããVBAã䜿çšããããšã§ãå®æçãªã¡ãŒã«éä¿¡ããã¡ã€ã«ã®ããã¯ã¢ãããªã©ãæ§ã ãªæ¥åãã¹ã±ãžã¥ãŒã«ã«åãããŠèªåå®è¡ããããšãå¯èœãšãªããŸãã
ã«ã¹ã¿ãã€ãºå¯èœãªUI
VBAã䜿çšãããšãExcelãWordã®ãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ïŒUIïŒãã«ã¹ã¿ãã€ãºããããšãã§ããŸããããã«ãããç¹å®ã®æ¥åã«ç¹åããããŒã«ãããã·ã¥ããŒããäœæããããšãå¯èœãšãªããŸããäŸãã°ãç¹å®ã®ããŒã¿å ¥åãã©ãŒã ããç¹å®ã®ã¬ããŒããçæããããã®ãã¿ã³ãªã©ãã«ã¹ã¿ãã€ãºãããUIãç°¡åã«è¿œå ããããšãã§ããŸãã
ããŒã¿ããŒã¹ãšã®é£æº
VBAã¯ãå€éšã®ããŒã¿ããŒã¹ãšã®é£æºãåŸæãšããŠããŸããããã«ããã倧éã®ããŒã¿ãå¹ççã«ç®¡çã»åæããããšãå¯èœãšãªããŸããäŸãã°ã瀟å ã®ããŒã¿ããŒã¹ããææ°ã®å£²äžããŒã¿ãååŸãããããåºã«ããã¬ããŒããèªåçæãããšãã£ãããšããVBAã䜿çšããŠç°¡åã«å®çŸã§ããŸãã
ãŸããVBAã䜿çšããããšã§ãããŒã¿ããŒã¹ã®ããŒã¿ãèªåçã«ExcelãWordã«åã蟌ã¿ããããåºã«ããåæãã¬ããŒãäœæãè¡ãããšãå¯èœãšãªããŸãã
VBAã§ã§ããããš
å€ãã®äººã ãVBAãéžæããçç±ã¯ããã®å€æ§ãªæ©èœãšå®çšæ§ã«ãããŸããVBAã䜿çšããããšã§ãæ¥åžžã®æ¥åããå°éçãªåæãŸã§ãå¹ åºãã¿ã¹ã¯ãå¹ççã«å®è¡ããããšãã§ããŸãã以äžã§ã¯ãVBAã§å®çŸã§ããäž»ãªæ©èœã«ã€ããŠè©³ãã解説ããŠãããŸãã
æ¥åžžã®æ¥åå¹çå
æ¥åžžã®æ¥åã«ãããŠãç¹°ãè¿ãè¡ãäœæ¥ãæéã®ãããã¿ã¹ã¯ã¯å€ãååšããŸããVBAã䜿çšããããšã§ããããã®äœæ¥ãèªååããå¹ççã«æ¥åãé²ããããšãã§ããŸããäŸãã°ãããŒã¿ã®å ¥åããã©ãŒãããã®çµ±äžãå®æçãªã¬ããŒãã®äœæãªã©ãVBAã®ãã¯ãã掻çšããããšã§ããããã®äœæ¥ãç°¡åã«èªååããããšãã§ããŸãã
è€éãªèšç®ã®èªåå
ç¹å®ã®æ¥çãå°éåéã«ãããŠã¯ãè€éãªèšç®ãæ±ããããããšããããŸããVBAã䜿çšããããšã§ããããã®èšç®ãããã°ã©ã ãšããŠèšè¿°ããç¬æã«çµæãåŸãããšãã§ããŸããããã«ãããèšç®ãã¹ã®ãªã¹ã¯ãäœæžããããè¿ éãªææ決å®ããµããŒãããŸãã
ã¬ããŒãã®èªåçæ
ããžãã¹ã®çŸå Žã§ã¯ãå®æçã«ã¬ããŒããäœæããããšãæ±ããããããšãå€ãã§ããVBAã䜿çšããããšã§ãããŒã¿ã®éèšãåæãã°ã©ãã®äœæãªã©ãã¬ããŒãäœæã«é¢é£ããå€ãã®äœæ¥ãèªååããããšãã§ããŸããããã«ãããã¬ããŒãã®å質åäžãäœææéã®ççž®ãæåŸ ã§ããŸãã
å€éšããŒã¿ã®åã蟌ã¿ãšåæ
VBAã¯ãå€éšã®ããŒã¿ããŒã¹ããŠã§ããµã€ãããã®ããŒã¿åã蟌ã¿ã«ã察å¿ããŠããŸããããã«ãããææ°ã®ããŒã¿ããªã¢ã«ã¿ã€ã ã§ååŸãããããåºã«ããåæãã¬ããŒãäœæãè¡ãããšãå¯èœãšãªããŸãããŸããVBAã䜿çšããããšã§ãããŒã¿ã®æŽåœ¢ãã¯ã¬ã³ãžã³ã°ãªã©ãããŒã¿åæã«å ç«ã€ååŠçãå¹ççã«è¡ãããšãã§ããŸãã
VBAã®å®çšçãªå¿çšäŸ
å€ãã®äŒæ¥ãå人ãVBAãå©çšããèæ¯ã«ã¯ããã®å®çšæ§ã®é«ãããããŸããæ¥åžžã®æ¥åããå°éçãªåæãŸã§ãVBAã掻çšããããšã§ããŸããŸãªã¿ã¹ã¯ãå¹çåããããšãã§ããŸãã以äžã§ã¯ãVBAã®å®çšçãªå¿çšäŸã«ã€ããŠè©³ãã解説ããŠãããŸãã
åšåº«ç®¡çã®èªåå
ååã®åšåº«ç®¡çã¯ãå€ãã®äŒæ¥ã«ãšã£ãŠéèŠãªæ¥åã®äžã€ã§ããVBAã掻çšããããšã§ãåšåº«ã®å ¥åºåº«æ å ±ã®èšé²ããåšåº«æ°ã®èªåèšç®ãããã«ã¯çºæ³šææ¡ãªã©ã®æ¥åãèªååããããšãã§ããŸããããã«ãããåšåº«ã®éå°ãäžè¶³ãé²ããå¹ççãªåšåº«ç®¡çãå®çŸããããšãã§ããŸãã
äŸãã°ã売äžããŒã¿ãšåšåº«ããŒã¿ãé£æºãããããšã§ãèªåçã«åšåº«ã®è£å ææ¡ãè¡ããã¯ããäœæããããšãèããããŸããããã«ãããé©åãªã¿ã€ãã³ã°ã§ã®çºæ³šãå¯èœãšãªããæ¥åã®å¹çåãæåŸ ã§ããŸãã
販売ããŒã¿ã®éèšãšåæ
販売ããŒã¿ã®æ£ç¢ºãªéèšãšåæã¯ãããžãã¹ã®æé·ããµããŒãããããã®éèŠãªèŠçŽ ã§ããVBAã䜿çšããããšã§ã倧éã®è²©å£²ããŒã¿ãå¹ççã«éèšãã売äžã®ãã¬ã³ãã顧客ã®è³Œè²·åŸåãåæããããšãã§ããŸãã
å ·äœçã«ã¯ãæ¥å¥ãæå¥ãååå¥ã®å£²äžéèšããç¹å®ã®ãã£ã³ããŒã³ã®å¹æåæãªã©ãããŸããŸãªè§åºŠããã®ããŒã¿åæãèªååããããšãå¯èœã§ããããã«ãããè¿ éãªææ決å®ãããŒã±ãã£ã³ã°æŠç¥ã®æé©åãæåŸ ã§ããŸãã
ã¹ã±ãžã¥ãŒã«ç®¡çã®æé©å
å€ãã®äŒæ¥ãå£äœã§ã¯ãã¹ã±ãžã¥ãŒã«ç®¡çã®ããã®ããŒã«ãã·ã¹ãã ãå°å ¥ããŠããŸããVBAã掻çšããããšã§ããããã®ããŒã«ã®æ©èœãããã«åŒ·åããã¹ã±ãžã¥ãŒã«ã®æé©åãèªåéç¥ããªãã€ã³ããŒã®èšå®ãªã©ã®æ©èœãè¿œå ããããšãã§ããŸãã
äŸãã°ãè€æ°ã®ãããžã§ã¯ããåæã«é²è¡ããŠããå Žåãããããã®ãããžã§ã¯ãã®é²æç¶æ³ãéèŠãªã¿ã¹ã¯ãäžèŠ§è¡šç€ºããããã·ã¥ããŒããäœæããããšãèããããŸããããã«ãããå šäœã®ã¹ã±ãžã¥ãŒã«ãäžç®ã§ç¢ºèªããããšãã§ããå¹ççãªã¿ã¹ã¯ç®¡çãå®çŸããŸãã
VBAãåŠã¶ããã®ã¹ããã
çŸä»£ã®ããžãã¹ã·ãŒã³ã§æ±ããããã¹ãã«ã®äžã€ãšããŠãVBAã®ç¥èãæããããŸããããããVBAããŒãããåŠã¶éã«ã¯ãã©ã®ãããªã¹ãããã§é²ããŠããã®ãè¯ãã®ã§ããããã以äžã§ã¯ãVBAãå¹æçã«åŠã¶ããã®ã¹ãããã«ã€ããŠè©³ãã解説ããŠãããŸãã
åºæ¬çãªããã°ã©ãã³ã°ç¥è
ãŸãæåã«ãããã°ã©ãã³ã°ã®åºæ¬çãªç¥èã身ã«ã€ããããšãéèŠã§ããå€æ°ãã«ãŒããæ¡ä»¶åå²ãªã©ã®åºæ¬çãªæŠå¿µãç解ããããšã§ãVBAã®ã³ãŒããèªã¿æžãããéã®åå°ãšãªããŸãããããã®æŠå¿µã¯ãä»ã®ããã°ã©ãã³ã°èšèªã§ãå ±éããŠãããããäžåºŠèº«ã«ã€ããŠããŸãã°ãä»ã®èšèªãåŠã¶éã«ã圹ç«ã¡ãŸãã
VBAã®ç°å¢èšå®
次ã«ãVBAãå®éã«äœ¿çšããããã®ç°å¢èšå®ãè¡ããŸããMicrosoft Officeã®äžã®ExcelãWordã«ã¯ãVBAã䜿çšããããã®ãšãã£ã¿ãçµã¿èŸŒãŸããŠããŸãããã®ãšãã£ã¿ãèµ·åãããã¯ãã®èšé²ãã³ãŒãã®å ¥åãè¡ãããšã§ãVBAã®ããã°ã©ã ãå®è¡ããããšãã§ããŸãã
ãŸããVBAã®ãšãã£ã¿ã«ã¯ãããã°æ©èœãåãã£ãŠãããã³ãŒãã®ãšã©ãŒãã§ãã¯ãã¹ãããå®è¡ãªã©ãè¡ãããšãã§ããŸããããã«ãããã³ãŒãã®åäœã確èªããªãããå¹æçã«ããã°ã©ã ãäœæããããšãã§ããŸãã
å®è·µçãªãããžã§ã¯ããéããåŠç¿
åºæ¬çãªç¥èãšç°å¢èšå®ãæŽã£ãããå®éã®ãããžã§ã¯ããéããŠVBAãåŠã¶ããšãããããããŸããäŸãã°ãæ¥åžžã®æ¥åã§ç¹°ãè¿ãè¡ã£ãŠããäœæ¥ãèªååãããã¯ããäœæãããç¹å®ã®ããŒã¿ãéèšã»åæããã¬ããŒããèªåçæãããªã©ãå®éã®æ¥åã«å³ãã課é¡ãèšå®ããŠãããã解決ããããã®ããã°ã©ã ãäœæããããšã§ãVBAã®ã¹ãã«ãå¹æçã«åäžãããããšãã§ããŸãã
ãŸããå®éã®ãããžã§ã¯ããéããŠåŠã¶ããšã§ãVBAã®æ©èœã ãã§ãªããããã°ã©ãã³ã°å šè¬ã®æèæ¹æ³ãåé¡è§£æ±ºã®ã¹ãã«ã身ã«ã€ããããšãã§ããŸãã
ãŸãšã
ãã®èšäºãéããŠãVBAã®åºæ¬çãªæŠå¿µããå®çšçãªå¿çšäŸãåŠã³ã®ã¹ããããŸã§ãå¹ åºãVBAã«ã€ããŠåŠã¶ããšãã§ããŸãããVBAã¯ããã®å€æ§ãªæ©èœãšå®çšæ§ã«ãããå€ãã®ããžãã¹ã·ãŒã³ã§æŽ»çšãããŠããŸãã
VBAã®å¯èœæ§ãæ倧éã«æŽ»çšããããã«
VBAãå¹æçã«æŽ»çšããããã«ã¯ããŸãåºæ¬çãªããã°ã©ãã³ã°ç¥èã身ã«ã€ããããšãéèŠã§ãããã®äžã§ãå®éã®æ¥åã«å³ãã課é¡ãèšå®ããããã解決ããããã®ããã°ã©ã ãäœæããããšã§ãVBAã®ã¹ãã«ãæ·±ããããšãã§ããŸãããŸããVBAã®æ©èœãæ倧éã«æŽ»çšããããã«ã¯ãå®æçãªåŠã³ãç¶ç¶çãªå®è·µãæ¬ ãããŸããã
ä»åŸã®åŠã³ã®æ¹åæ§
VBAã¯ããã®åºæ¬çãªæ©èœã ãã§ãªããããŸããŸãªæ¡åŒµæ©èœãå€éšããŒã«ãšã®é£æºãªã©ãæ·±ãç¥èãèŠããéšåãå€ãååšããŸããä»åŸã¯ãVBAã®é«åºŠãªæ©èœããä»ã®ããã°ã©ãã³ã°èšèªãšã®é£æºãªã©ãããã«å¹ åºãç¥èã身ã«ã€ããããšã§ãããé«åºŠãªã¿ã¹ã¯ã«ã察å¿ã§ããããã«ãªãããšãæåŸ ãããŸãã
ãŸããVBAã®åŠã³ãéããŠãããã°ã©ãã³ã°å šè¬ã®æèæ¹æ³ãåé¡è§£æ±ºã®ã¹ãã«ã身ã«ã€ããããšãã§ããŸãããããã®ã¹ãã«ã¯ãVBAã ãã§ãªããä»ã®ããã°ã©ãã³ã°èšèªãããŒã«ãåŠã¶éã«ã圹ç«ã€ãããå¹ åºãåéã§ã®æŽ»èºãæåŸ ãããŸãã