ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[Âà¶K] ¦p¦ó¥¿½T«Å§i

[Âà¶K] ¦p¦ó¥¿½T«Å§i

©Ò¿×VBA«O¯d¦r¬OVBA©Ò¦³»yªk·|¥Î¨ìªº¦rµü¡A³o¨Ç¦rµü¥]§t¦b
©Ò¦³µ{§Ç¡B«Å§i¡B¨ç¼Æ¡Bª«¥ó¡B¨Æ¥ó¡B¤èªk¡BÄÝ©Ê¡B³¯­z¦¡¡BVBA±`¼Æ... µ¥µ¥¡A
¦Ó¤£¥]¬A¨Ï¥ÎªÌ¦Û­qªºÅܼơB±`¼Æ¡C

¦³­Ó²©öªº¤èªk¥i¥H±oª¾¬Y­Ó¦r¬O¤£¬OVBA«O¯d¦r --
¦bVBA½s¿èµøµ¡¤U¡A¤]´N¬O¼gµ{¦¡ªº®É­Ô¡A
¥´§¹¤@­Ó¦r¡A´å¼ÐÂ÷¶}¨º¤@¦æ¡A
¦pªG³o­Ó¦rÅܦ¨²`ÂŦâ(¹w³]­È)©ÎÅܦ¨­º¦r¥À¤j¼g¡A
¨º»ò³o­Ó¦r¤@©w¬OVBA«O¯d¦r¡C

VBA±`¼Æ¬O¨Ò¥~ (µù)¡A
§Y«K¬O¤º«Ø±`¼Æ¤]¤£·|¦Û°ÊÅܦâ¡A¤]¤£¤@©w·|ÅÜ­º¦r¥À¤j¼g (xl °£¥~)¡C
¦Ó¥B¾Ú§Ú©Òª¾¦bVBA help¤¤Excel VBA±`¼Æ¨Ã¨S¦³¿W¥ßªº¦Cªí¤Î»¡©ú¡A
¥¦­Ìªº»¡©ú©¹©¹¬OªþÄݦb©ÒÄݪº¤èªk©ÎÄÝ©Ê»¡©ú¸Ì­±¡C
¨Ò¦p·Qª¾¹D xlAutomatic ªº·N¸q´N­n§ä Calculation Äݩʪº»¡©ú¡C
(¦Ü©óVB±`¼Æ­Ë¬O¦³¿W¥ßªº¦Cªí»¡©ú)
¦ýÄÝ©Ê»¡©ú¤@©w¦³±`¼Æªº¸ÑÄÀ¶Ü? ¤]¤£ºÉµM¡C
¥H Calculation Äݩʬ°¨Ò¡A¥¦¥u¦C¥X¥i¥Î±`¼Æ
xlCalculationAutomatic¡BxlCalculationManual¡BxlCalculationSemiautomatic
¦Ó¨S¦³¶i¤@¨B»¡©ú (PS. Excel2000)¡C
¦³¨Ç²LÅã©öÀ´ªº±`¼Æ±q¦r­±¤W´N¥iÁA¸Ñ¡A§_«h¤]¥u¦n¸I¹B®ð¤F§a¡C
»¡¤£©wºô¸ô¤W¦³ Microsoft ªº documentation¡A©Î¬O
§ä¨ì¦³¦C¥X©Ò¦³±`¼Æ»¡©úªº®Ñ (¾÷²v§ó¤p) ...

µù¡G
Excel VBA±`¼Æ¥H xl ¶}ÀY¡A¦p xlUp, xlDown, xlPart...
Word VBA±`¼Æ¥H wd ¶}ÀY¡A¦p wdLine, wdFindStop, wdPrintCurrentPage...
VB ±`¼Æ¬O¾A¥Î©Ò¥ÎVBAÀô¹Ò¡A¦p vbBlue, vbRed, vbLf ...

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD