1. ã¯ããã«
1.1 VBAã®éèŠæ§
1.2 ãã®èšäºã®ç®ç
2. VBAãšã¯
2.1 VBAã®åºæ¬æŠå¿µ
2.2 VBAã䜿ãããå Žé¢
3. VBAã®åºæ¬æäœ
3.1 Excelã§ã®VBAã®äœ¿ãæ¹
3.2 ã¢ããªã±ãŒã·ã§ã³æ¯ã®VBAã®ç¹åŸŽ
3.3 䟿å©ãªVBAã®é¢æ°
4. VBAãåŠã¹ãè¯è³ªãªãµã€ã玹ä»
4.1 ç¡æã§åŠã¹ããµã€ã
4.2 ææã§åŠã¹ããµã€ã
4.3 ããããã®ãµã€ãã®ç¹åŸŽãšè©äŸ¡
5. VBAã®åŠç¿ã«ããã泚æç¹ãšãã€ã³ã
5.1 VBAåŠç¿ã®ããã®åæç¥è
5.2 VBAåŠç¿ã®é »åºŠãšç¶ç¶æ§
5.3 ã¹ãã«ç¿åŸãŸã§ã®å ·äœçãªã¹ããã
6. ãŸãšã
6.1 VBAãäžããåŠã¶ããã«
6.2 VBAã掻ããããã«
—
1. ã¯ããã«
çŸä»£ç€ŸäŒã«ãããæ å ±åŠçã®ã¹ãã«ã¯ã絶倧ãªéèŠæ§ãæã£ãŠããŸãããã®ä»£è¡šçãªãã®ãšããŠããã¯ãèšèªVBAãæããããŸãã
1.1 VBAã®éèŠæ§
VBAïŒVisual Basic for ApplicationsïŒã¯ããã€ã¯ããœãããéçºãããã¯ãèšèªã§ãWordãExcelãªã©ã®ãªãã£ã¹ã¢ããªã±ãŒã·ã§ã³ãèªåæäœããããã®ãã®ã§ããæ¥åã®çååãå¹çåã«éèŠãªåœ¹å²ãæãããŸããç¹ã«ãšã¯ã»ã«VBAã¯ãè¡šèšç®ãœãããšããŠã»ãšãã©ã®äŒæ¥ã§å©çšãããŠããExcelããã匷åã«ãããå¹ççã«å©çšããããã«æ¬ ãããªãã¹ãã«ãšãªã£ãŠããŸãã
äŸãã°ãããããã決ãŸã£ããã©ãŒãããã®å ±åæžãäœæããå Žåãæ¯ååãæäœãæåã§è¡ããšæéãããããŸããã§ããããããã®æäœãVBAã§ããã°ã©ãã³ã°ããŠããŸãã°ããã¿ã³äžã€ã§å¹çè¯ãåŠçãå®äºã§ããŸãããããVBAã®éèŠæ§ã§ãã
1.2 ãã®èšäºã®ç®ç
ãã®èšäºã®ç®çã¯ãVBAãåŠã³ãããšæã£ãŠããã¿ãªããããã©ãã§ã©ã®ããã«åŠç¿ãé²ããŠããã°è¯ãã®ãããšããçåã«çããããšã§ãã
ããããVBAã¯å°éæ§ã®é«ãåéãªã®ã§ãã¯ããã¯äœããæãã€ããŠããã®ãè¿·ãããšã§ããããããã§ããã®èšäºã§ã¯ãVBAã®åºæ¬çãªæŠå¿µããåŠã¹ããªã³ã©ã€ã³ã®åŠç¿ãµã€ããVBAã®åŠç¿ã«ããã泚æç¹ããã€ã³ããªã©ãå®è·µçãªåŠç¿ãé²ããŠããããã®æ å ±ãæäŸããããŸãã
ãããèªãããšã§ãåå¿è ã§ãå®å¿ããŠVBAåŠç¿ãå§ããããããšãç®æããŠããŸããèªäºåŸã«ã¯ãVBAã®åŠç¿ã«å¯Ÿããäžå®ãææããã次ã®ã¹ãããã«é²ãããã®æ確ãªéçãèŠããŠããããšã§ãããã
2. VBAãšã¯
VBAããã®å称ã¯Visual Basic for Applicationsã®ç¥ã§ãMicrosoftãéçºããããã°ã©ãã³ã°èšèªã§ãããã®èšèªã¯ãMicrosoft Officeã®å補åïŒExcelãWordãªã©ïŒå ã§åäœããããã°ã©ã ãäœæããããã®èšèªãšãªããŸãã
2.1 VBAã®åºæ¬æŠå¿µ
ãŸããVBAã¯åºæ¬çã«ã€ãã³ãé§ååããã°ã©ãã³ã°èšèªã§ãããç¹å®ã®ã€ãã³ãïŒäŸïŒãã¿ã³ãã¯ãªãã¯ãããã»ã«ã«ããŒã¿ãå ¥åãããªã©ïŒãããªã¬ãŒãšãªã£ãŠããã°ã©ã ãå®è¡ãããŸãã
ãŸãããã¯ããšããåèªããã°ãã°ç®ã«ããŸãããããã¯VBAãçšããŠèšè¿°ãããå°ããªããã°ã©ã ã®ããšãæããŸããå ·äœçãªäœæ¥ãèªååããããã«äœ¿ããããã®äœæ¥ç¯å²ã¯åçŽãªå ¥åæ¯æŽããè€éãªããŒã¿åæãŸã§æ§ã ã§ãã
ãããŠãVBAã§ã¯ãªããžã§ã¯ãæåããã°ã©ãã³ã°ã®èãæ¹ãåãå ¥ããããŠãããOfficeã®åã¢ããªã±ãŒã·ã§ã³ãæ§æããèŠçŽ ïŒã¯ãŒã¯ã·ãŒããã·ã§ã€ããã¬ã³ãžãªã©ïŒããªããžã§ã¯ããšããŠæ±ãããŸãããããã®ãªããžã§ã¯ãã«å¯ŸããŠæ§ã ãªæäœïŒã¡ãœããïŒãè¡ã£ãããæ å ±ïŒããããã£ïŒãåãåºãããããããšã«ãã£ãŠãé«åºŠãªæ©èœãå®çŸããŸãã
2.2 VBAã䜿ãããå Žé¢
VBAã䜿ãããå Žé¢ã¯å€å²ã«ããããããã¯åã ã®ãŠãŒã¶ãŒã®çšéãšãã®æè¡åã«ãã£ãŠå€§ããå€ãããŸãããããäž»ã«ããšã¯ã»ã«äžã®ç¹°ãè¿ãäœæ¥ã®èªååããç¹å®ã®æ¡ä»¶äžã§ã®éèšã»åæãªã©ãæäœæ¥ã«ããäœæ¥æéã®ççž®ãééããèŠçŽ ã®æé€ãšãã£ãããšãæ±ããããå Žé¢ã§å©çšãããŸãã
äžè¬äºåäœæ¥ã ãã§ãªããããŒã¿åæãã°ã©ãã£ãã¯èšèšãã·ã¹ãã 管çãªã©ãããŸããŸãªæ¥åã§VBAã¯æå¹ãªæ段ãšããŠæŽ»çšãããŠããŸãã
VBAã®åºæ¬æäœ
Excelã§ã®VBAã®äœ¿ãæ¹
ExcelãšVBAã¯éåžžã«çžæ§ãè¯ããVBAã¯Excelã®æäœããã䟿å©ãã€å¹ççã«ãã匷åãªããŒã«ãšãªã£ãŠããŸããExcelã§VBAã䜿çšãããŸãæåã®ã¹ãããã¯ãéçºã¿ããéããVBEïŒVisual Basic EditorïŒãéãããšã§ããVBEãéããããæ°ããã¢ãžã¥ãŒã«ãè¿œå ãããã®äžã«ã³ãŒããèšè¿°ããŸãããã®åŸãããŒã«ããŒã®ãå®è¡ãããããµãã«ãŒãã³ã®å®è¡ããéžã³ãäœæããã¢ãžã¥ãŒã«ãéžæããŠå®è¡ããŸããããã§VBAãExceläžã§åäœããããŒã¿ã®æäœãèªååãå¯èœãšãªããŸãã
ã¢ããªã±ãŒã·ã§ã³æ¯ã®VBAã®ç¹åŸŽ
Microsoft Officeã®åã¢ããªã±ãŒã·ã§ã³ã«ã¯ç¬èªã®VBAãããããã®ç¹æ§ã¯ã¢ããªã±ãŒã·ã§ã³ã«ããç°ãªããŸããããšãã°ãäžèšã®Excelã®å Žåãã»ã«ãžã®ããŒã¿ã®å ¥åã»æäœã»æŽçãšãã£ãäºãåŸæã§ããå¯Ÿç §çã«Accessã§ã¯ãããŒã¿ããŒã¹ã®æäœã管çãWordã§ã¯ææžã®ç·šéããã©ãŒãããã®èšå®çã«ç¹åããŠããŸãã
䟿å©ãªVBAã®é¢æ°
VBAã«ã¯æ§ã ãªäŸ¿å©ãªé¢æ°ãååšããŸããããã®äžã§ãç¹ã«ãã䜿ãããé¢æ°ã¯ä»¥äžã®3ã€ã§ãã
⢠MsgBoxé¢æ° : ã¡ãã»ãŒãžããã¯ã¹ã衚瀺ãããŠãŒã¶ãŒã«æ å ±ãæäŸãããããŠãŒã¶ãŒããã®å ¥åãæ±ãããããŸãã
⢠InputBoxé¢æ° : ãŠãŒã¶ãŒã«ããã¹ãå ¥åãæ±ãããã€ã¢ãã°ããã¯ã¹ã衚瀺ããŸãããŠãŒã¶ãŒã®å ¥åãå€æ°ã«æ ŒçŽããããšãã§ããŸãã
⢠Rangeé¢æ° : æå®ããç¯å²ã®ã»ã«ãæäœããŸããã»ã«ã®å 容ã®ååŸããæžãæããªã©ã«å©çšãããŸãã
ãããã®é¢æ°ãå©çšããããšã§ãVBAã®ããã°ã©ãã³ã°ããã䟿å©ã§å¹ççã«ãªããããè€éãªæäœãå¯èœã«ãªããŸãã
4. VBAãåŠã¹ãè¯è³ªãªãµã€ã玹ä»
ããŠãããããã¯VBAãåŠã¹ãè¯è³ªãªãµã€ãã«ã€ããŠã玹ä»ããŠãããŸããããåŠç¿ãªãœãŒã¹ã¯ç¡æã®ãã®ããææã®ãã®ãŸã§ããŸããŸã§ããããããã®ç¹åŸŽãèžãŸããäžã§ãèªåã«åã£ããµã€ããéžã¶ããšã倧åã§ããã§ã¯æ©éãèŠãŠãããŸãããã
4.1 ç¡æã§åŠã¹ããµã€ã
ãŸãæåã«ã玹ä»ããã®ã¯Microsoftã®å ¬åŒãµã€ãã§ããããã«ã¯ãVBAã®åºæ¬çãªç¥èãã詳现ãªé¢æ°ã®èª¬æãŸã§ãæ§ã ãªæ å ±ãå å®ããŠããŸããããã«ãåå¿è åãã®ãã¥ãŒããªã¢ã«ãæäŸãããŠãããVBAã®åºæ¬ããã£ãããã¹ã¿ãŒããã®ã«é©ããŠããŸãã
次ã«ãå€ãã®åå¿è ãå©çšããŠããStack Overflowãã玹ä»ããŸããå ·äœçãªåé¡ã«å¯ŸããåçãèŠã€ããããšãã§ããåé¡è§£æ±ºã®åèã«ãªããŸãããŸããèªåèªèº«ã質åãæçš¿ããããšãå¯èœã§ãå°ã£ãæç¹ã§çŽæ¥åãåãããããšãã§ããŸãã
4.2 ææã§åŠã¹ããµã€ã
次ã«ãææã®åŠç¿ãµã€ãã§ãããŸãã玹ä»ããã®ã¯Udemyã§ããUdemyã¯ãè¬åº§ããšã«åå æãèšå®ãããŠãããäžåºŠè³Œå ¥ããã°äœåºŠã§ãèŠèŽããããšãã§ããŸãããŸããå®è·µçãªäºäŸãåŠã¶ããšãã§ããç¬èªã®ã¢ããªã±ãŒã·ã§ã³éçºã«åœ¹ç«ã¡ãŸãã
ããã«ãVBAå°éã®åŠç¿ãµã€ãVBAãã¬ãŒãã³ã°ãããããã§ããåå¿è ããäžçŽè ãŸã§å¯Ÿå¿ããå ·äœçãªè¬åº§ãèšããããŠãããè·å Žã§åœ¹ç«ã€å®è·µçãªã¹ãã«ãåŠã¹ãŸãã
4.3 ããããã®ãµã€ãã®ç¹åŸŽãšè©äŸ¡
ããã§ã¯ãããããã®ãµã€ãã®ç¹åŸŽãšè©äŸ¡ã«ã€ããŠèª¬æããŸãããŸãç¡æã®ãµã€ããMicrosoftã®å ¬åŒãµã€ãã¯ãVBAã®åºæ¬ç¥èã身ã«ã€ããã®ã«æé©ãªãµã€ãã§ãããªã³ã©ã€ã³ã§ç¡æã§åŠã¹ãVBAéçºã®åºç€ãåŠã¹ãç¹ãé«ãè©äŸ¡ãããŠããŸãã察ããŠStack Overflowã¯ãå ·äœçãªåé¡è§£æ±ºã«åŒ·ããµã€ãã§ããã³ãŒãã®ãšã©ãŒå 容ãæçš¿ããããšã§ãäžçäžã®ããã°ã©ããŒããç確ãªã¢ããã€ã¹ããããããšãã§ããŸãã
äžæ¹ã§ãææã®ãµã€ãã¯ããæ·±ãVBAãåŠã³ããæ¹ã«ããããã§ããUdemyã§ã¯äžã€äžã€ã®è¬åº§å 容ãæ確ã§ãèªåãäœãåŠã³ããã®ãããã£ãŠããæ¹ã«é©ããŠããŸããVBAãã¬ãŒãã³ã°ã¯ãä»äºã«æŽ»ããããšãç®æãæ¹ã«ãªã¹ã¹ã¡ã§ããããã®è¬åž«ãå ·äœçãªåé¡è§£æ±ºã®ããã®ã¹ãã«ãæããŠãããŸãã
5. VBAã®åŠç¿ã«ããã泚æç¹ãšãã€ã³ã
VBAã®åŠç¿ãå§ããéã«ã¯ãããã€ãã®æ³šæç¹ããã€ã³ãããããŸããããã§ã¯ãVBAåŠç¿ã«å¿ èŠãªåæç¥èãåŠç¿ã®é »åºŠãšç¶ç¶æ§ããããŠã¹ãã«ç¿åŸãŸã§ã®å ·äœçãªã¹ãããã«ã€ããŠè©³ãã解説ããŸãã
5.1 VBAåŠç¿ã®ããã®åæç¥è
ãŸãæåã«ãVBAåŠç¿ã®ããã®åæç¥èãšããŠãã³ã³ãã¥ãŒã¿ã®åºæ¬æäœã«æ £ããŠããããšãæ±ããããŸããå ·äœçã«ã¯ãããŠã¹ãããŒããŒãã䜿ã£ãæäœããã¡ã€ã«ã®ä¿åãšéãæ¹ããããŠWindowsãMacãšãã£ãOSã®åºæ¬çãªæäœæ¹æ³ãªã©ã§ãã
次ã«ãVBAã¯Microsoft Officeã®äžéšãšããŠå«ãŸããŠãããç¹ã«Excelã§ã®å©çšãå€ããããExcelã®åºæ¬æäœãåæç¥èãšããŠç解ããŠãããšè¯ãã§ãããããŸããããã°ã©ãã³ã°çµéšããããšå°è¯ãã§ããããªããŠãå§ããããŸãã
5.2 VBAåŠç¿ã®é »åºŠãšç¶ç¶æ§
VBAãåŠã¶éã«éèŠãªã®ããåŠç¿ã®é »åºŠãšç¶ç¶æ§ã§ããæ¬æ Œçã«VBAãåŠã³ããå Žåãæ¯æ¥å°ããã€åŠç¿æéã確ä¿ããç¶ç¶çã«åŠã¹ãç°å¢ãæŽããããšã倧åã§ãã
äžåºŠã«é·æéåŠç¿ããããããæ¯æ¥çæéãç©ã¿éããããšã§ãç解åãæ·±ãŸããæ°ããç¥èãå®çããããããšãç¥ãããŠããŸãã
5.3 ã¹ãã«ç¿åŸãŸã§ã®å ·äœçãªã¹ããã
VBAã®ã¹ãã«ãç¿åŸããããã®å ·äœçãªã¹ããããšããŠã¯ã以äžã®æµããäžè¬çã§ãã
ã¹ããã1ïŒVBAãšã¯äœããç解ãã
ãŸãã¯ãVBAãäœã§ããããç解ããŸãããããã®äžã§ããã®ç¹æ§ã䜿ãæ¹ããããŠã©ã®ãããªå Žé¢ã§äœ¿ãã®ããææ¡ããããšãæåã®ã¹ããããšãªããŸãã
ã¹ããã2ïŒåºæ¬çãªææ³ãèŠãã
次ã«ãVBAã®åºæ¬çãªææ³ãèŠããŸããææ³ã¯ããã°ã©ãã³ã°ã®åºç€ã§ãã®ã§ãããããã£ãããšç解ã§ããŠããªããšåŸã®ã¹ããããé£ãããªããŸãã
ã¹ããã3ïŒå®éã«ã³ãŒããæžããŠã¿ã
çè«ã ãã§ãªããå®éã«VBAã®ã³ãŒããæžããŠã¿ãŸããããåãã¯ç°¡åãªãã®ããå§ããåŸã
ã«è€éãªã³ãŒããæžãããã«ããããšã§ã¹ãã«ã身ã«ã€ããŸãã
ã¹ããã4ïŒåé¡ã解ããŠã¿ã
ããã«äžéããããã«ã¯ãå®éã®åé¡ã解ãç·Žç¿ãè¡ãããšã§ããå®éã®æ¥åãåŠç¿ãµã€ãã®åé¡éã䜿ã£ãŠãèªåã§èããŠã³ãŒããæžãããšã§ãããæ·±ãç解ãåŸãããšãã§ããŸãã
6. ãŸãšã
ãã®èšäºãéããŠãå€ãã®æ¹ãVBAã®åŠç¿ã«å¯Ÿããæ°ããªèŠç¹ãåŸãããšãã§ããããšã匷ãé¡ã£ãŠããŸããèšç®ãäœæ¥ã®èªååãæ±ããããçŸä»£ç€ŸäŒã§ã¯ããšã¯ã»ã«ã®æäœãäžæ®µéé²åãããVBAã®ã¹ãã«ã¯ã誰ã«ãšã£ãŠãéåžžã«æçã§ãããšèšããã§ãããã
6.1 VBAãäžããåŠã¶ããã«
ãŸãã¯ãVBAãäžããåŠã¶ããã®ãã€ã³ããå床確èªããŠã¿ãŸãããã
åºæ¬æäœã®ç解 ïŒVBAã®åºæ¬æäœãèŠããããšããå§ããŸããã³ãŒãã®æžãæ¹ãåºæ¬çãªé¢æ°ã®äœ¿ãæ¹ããšã¯ã»ã«ã§ã®å®è¡æ¹æ³ãªã©ãç解ããããšã倧åã§ãã
ç¶ç¶çãªåŠç¿ ïŒVBAã¯äžæ¥ãäºæ¥ã§ãã¹ã¿ãŒãããã®ã§ã¯ãããŸãããå®æçã«åŠã³ãæ·±ããããšã§ã段éçã«ã¹ãã«ãé«ããŠããããšãã§ããŸãã
è¯è³ªãªåŠç¿ãµã€ãã®æŽ»çš ïŒãã®èšäºã§çŽ¹ä»ããåŠç¿ãµã€ãã掻çšããããšã§ãèªå·±åŠç¿ãããå¹ççãªãã®ã«ããããšãã§ããŸããç¡æãµã€ãããææãµã€ããŸã§ãèªåã®åŠç¿ã¹ã¿ã€ã«ãäºç®ã«åãããŠéžæã§ããŸãã
6.2 VBAã掻ããããã«
VBAãåŠãã åŸã¯ããããã©ã®ããã«æŽ»ããããéèŠãªãã€ã³ãã«ãªããŸãã
æ¥åžžæ¥åãžã®å¿çš ïŒãšã¯ã»ã«äœæ¥ã«ãããç¹°ãè¿ãæäœãè€éãªäœæ¥ãVBAã§èªååããããšã§ãæ¥åã®ããžã¿ã«ãã©ã³ã¹ãã©ãŒã¡ãŒã·ã§ã³ãå®çŸã§ããŸãã
åé¡è§£æ±ºã¹ãã«ã®åäž ïŒVBAã䜿ãããšã§ãããŸããŸãªåé¡ã«å¯ŸããŠããã°ã©ã ãäœæãã解決ããèœåã身ã«ã€ããããšãã§ããŸããããã¯ãåé¡è§£æ±ºã¹ãã«ã®åäžã«ãç¹ãããŸãã
ã¹ãã«ã¢ããã®ããã®ææŠ ïŒåžžã«æ°ããé¢æ°ãã³ãŒããè©Šããèªåã®VBAã¹ãã«ãé²åãããŠããããšã§ããã倧ããªæ¥çžŸãäžããããšãå¯èœã«ãªããŸãã
以äžã«ãªããŸãããVBAåŠç¿ã¯ãã ã®ããã°ã©ãã³ã°ã¹ãã«ç¿åŸä»¥äžã®ãã®ã§ããèªåã®æ¥åãèªååããåã身ã«ã€ããããšã§ãéåžžã«å€ãã®æéã確ä¿ã§ãããã£ã³ã¹ãæŽãã§ãã ããã