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

[µo°Ý] Set ªº¨Ï¥Î®É¾÷°ÝÃD

[µo°Ý] Set ªº¨Ï¥Î®É¾÷°ÝÃD

¦b®Ñ¤W§Ú©Ò¬Ý¨ìªº¥H¤Î§Ú¥­±`²ßºD¨Ï¥ÎªºSetÃöÁä¦r
¬O¥Î¨Ó¹ïÅܼƶi¦æ½á­È®É¨Ï¥Î
¤ñ¦p»¡
Dim x as integer
set x =1

¦ý³Ìªñ§Ú¤@ª½¹J¨ì¤@­Ó°ÝÃD
½Ð¬Ý¥H¤U½s½X(¸`¿ý³¡¤À)

Result_Month = CommandBars("Control").Controls(1).ListIndex
¥H¤W½á­Èµ²ªG¬O1

Q:°ÝÃD¨Ó¤F,·í¥H¤W¦r¥yªº¶}ÀY¥[¤WSetÃöÁä¦r®É,«o¤£Â_¦bdebug¼Ò¦¡¤U¥X²{"¦¹³B»Ý­nª«¥ó"ªº°T®§
     Set Result_Month = CommandBars("Control").Controls(1).ListIndex
     ·Q½Ð°Ý¥¿½TªºSetÃöÁä¦rÀ³¸Ó­n¦p¦ó¨Ï¥Î¤~¹ï©O??§Ú·Q§ó²M·¡¤F¸Ñ

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-10-9 21:43): ¬O³o¼Ë¨S¿ù

§Ú·Q§Ú¤j·§ª¾¹D°ÝÃD¥X¦b­þ¸Ì¤F
¤£½T©w¬O¤£¬OSet³o­Ó¦r¥u¯à¦b¬°Åܼƽá»Pª«¥ó®É¤~·|¨Ï¥Î
¦Ó¤@¯ë¹ïÅܼƽá­È®É(½á»P¼Æ­È©Î¤½¦¡)¬O¤£¥Îsetªº
¬O³o¼Ë¶Ü? ¦U¦ì¤j¤j??

TOP

¦^´_ 2# kioskyline
¤£À´VBAªº¨ç¼Æ,¤èªk,ÄÝ©Ê,¥i¦bVBA½s¿èµøµ¡«öF1,¦³»¡©ú
  1. Set ³¯­z¦¡
  2. «ü©wª«¥ó¤Þ¥Îµ¹ÅܼƩÎÄÝ©Ê¡C
  3. »yªk
  4. Set objectvar = {[New] objectexpression | Nothing}
  5. Set ³¯­z¦¡ªº»yªk¨ã¦³¤U¦C´X­Ó³æ¤¸¡G
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD