ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD