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

VBA¬O§_¥i¥H«Ø¥ß°ÊºAUserForm

VBA¬O§_¥i¥H«Ø¥ß°ÊºAUserForm

½Ð±Ð¦U¦ì°ª¤â¡A¤£ª¾¹DVBA¬O§_¯à«Ø¥ß°ÊºAªºUserForm¡A¤Î§Y®É¨M©w³o­Ó°ÊºAªºµøµ¡¸Ì­±ªº±±¨î¶µ¼Æ¥Øªº¦h¤Ö©O¡H
¨Ò¦p¡Aµ{¦¡¦b°õ¦æ¤¤¡A·|§ì¨ú¤£¦P¸ê®Æªº¤H¼Æ¡A¨C¤@­Ó¸ê®Æ°Ï¶ôªº¤H¼Æ¤£¦P¡A­n²£¥Íµøµ¡¨Ó§@¿ï¾Ü¨º¨Ç¤H¬OÁÙ­n«O¯d¦b¸s²Õ¤º¡A¥i¯à²Ä¤@­Ó¸s²Õ¤º¦³4­Ó¦¨­û¡A§Ú»Ý­n¤@­Ó°ÊºAµøµ¡¸Ì­±¦³¥|­Ó¤H¦WªºCheckBox¡AÅý§Ú¿ï¾Ü«O¯d¤U¨Óªº¤H¡A±µ¤U°õ¦æ²Ä¤G¸s²Õ¡A¸Ì­±¥i¯à¦³¤K­Ó¤H¡A¨º´N­n°ÊºA²£«~¤@­Óµøµ¡¡A¸Ì­±¦³¤K­Ó¹ïÀ³ªºCheckBox¡A¥Ñ©óµ{¦¡·|¦]§ì¨ì¸s²Õ§PÂ_¸Ì­±ªº¤H¼Æ¦A¨Ó²£«~¬Û¹ïÀ³¼Æ¶qªºCheckBox¡A³o¼Ëµ{¦¡¦³¿ëªk¼g¶Ü¡HÁٽЦU¦ì°ª¤âµ¹¤©¶}¸Ñ¡A·PÁ±z­Ì
clio

ÁÂÁÂ!!§Ú¤w¸g¸Ñ¨M¤F!!

TOP

°w¹ï³o­Ó·Q½Ð°Ý«e½ú¡A§Ú°ÊºA²£¥Í¤F¤@­Ólabel¦ý¬O«oµLªkÅã¥Ü¦bframe¸Ì¡A³o¤S¸Ó¦p¦ó¸Ñ¨M?
modelcrazyer µoªí©ó 2016-3-27 21:03



    ½Ð´£¨Ñ¸Ó°ÝÃD°Ï°ìªº­ì©l½X ¥H«K¨ó§U

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

°w¹ï³o­Ó·Q½Ð°Ý«e½ú¡A§Ú°ÊºA²£¥Í¤F¤@­Ólabel¦ý¬O«oµLªkÅã¥Ü¦bframe¸Ì¡A³o¤S¸Ó¦p¦ó¸Ñ¨M?

TOP

¦^´_  mark15jill

«e½ú¡A§Ú¤ñ¸û¤£·|»¡¸Ü¡A¹ï¤£°_
¦]¬°¯uªº¨Ó³oÃä§ä¸ê®Æªº®É¶¡¤£¤[¡A¨ä¹ê³o­Ó°ÝÃD§xÂZ§Ú ...
clio µoªí©ó 2016-3-24 17:04



    ¤£¥Î·Q¤Ó¦h   §Ú¤W¦¸µoªº¨º¬q¸Ü  ¥u¬O®Ú¾Ú§A¦^ÂЧڪº¤º®e ¥[¥H¦^ÂЦӤw
    ¦Ü¤Ö §AÁ٫ܦ³Â§»ª..  ¦³¨Ç¤H °Ý¤F ±o¨ìµª®×  ´N ¤£¨£¤H¼v   µ¥¤U¦¸¦³°ÝÃD ¤~¤S¥X²{...
   
     µ¹§A§Ú¤§«e§Ë±o ©M ¦¬¶° ªºµ{¦¡°Ñ¦Ò
    Code.rar (37.89 KB)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 6# mark15jill

«e½ú¡A§Ú¤ñ¸û¤£·|»¡¸Ü¡A¹ï¤£°_
¦]¬°¯uªº¨Ó³oÃä§ä¸ê®Æªº®É¶¡¤£¤[¡A¨ä¹ê³o­Ó°ÝÃD§xÂZ§Ú«Ü¤[¤F¡A´X¦~«e¦³°Ý¹L¬Û¦PªºÃD¥Ø¡A¨º®É±o¤£¨ì¦nªº¨M¸Ñ¤è¦¡¡A¤]§ä¤F´X¥»®Ñ¡A°Ý¤F¤@¨Ç¦P¨Æ¡A¸g¹L¤G¤T¦~«á¡A¯uªº¦³¹J¨ì«D«Ø¥ßUserForm¤£¥iªºÃøÃD
¦bºô¸ô¤W§ä¤F¤@¨Ç¸ê°T¡A¦³¹J¨ì¦³¤H¤¶²Ð¨Ó³Â»¶®a±Úªº½×¾Â¡A©Ò¥Hµo°Ý¤F¤@¨Ç°ÝÃD¡A¤]¦³«Ü¦h«e½úªº«üÂI¡A·íµM§Ú¤]¹J¨ì¤@¨Ç¥dÃö¡A³o¤G¤Ñ¤@ª½¬ã¨s¡A¤~§ä¨ì¬O³]©wªº°ÝÃD¡A¤]¬O¦]¬°³o¤G¤Ñ¤@ª½¦b½×¾Â§ä¸ê®Æ¤]ª¦
¤å¨ì«e«D«ü¤Þªº³o¤@«h¤å¡A¤§«e¦³½ú°Ý¹L¬Û¦Pªº°ÝÃD¡A³o­Ó¯uªº«Ü¹ï¤£°_¡A¬O§Úªº²¨¥G¡A«Ü·PÁ±zµ¹§Úªº«ü¤Þ¡A¯uªº«Ü·PÁ±z¡A¦³³y¦¨©p¤£µÎªAªº¦a¤è¡A¯uªº«Ü¹ï¤£°_¡AÁٽШ£½Ì¡A§Ú·|¦hª`·Nªº
clio

TOP

¦^´_  mark15jill

·PÁ¤j¤j¡A³o­Ó§Ú·|¤F¡A¦³ª¦¤å¤F¡A¤§«e¦³¤Hµoªí¹LÃþ¦üªº¡A·PÁ±zªº¦^ÂÐ
clio µoªí©ó 2016-3-24 16:04



    §A³o¼Ë·|Åý¤H¤£·Q¸Ñµª...  ¤£ª¦¤å  ¤H®a´£¥Ü«á »¡§A·|...

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 11# jackyq

·PÁ«e½úªº§iª¾¡A§Ú¤Sª¦¤F¤@¤U¤å¡Aµo²{§Ú»Ý­n¦b¦w¥þ³]©w¨ºÃä¦A§â¡u«H¥ô¦s¨úVBA±M®×ª«¥ó¼Ò«¬(V)¡v¤Ä¿ï°_¨Ó¡A³o¼Ë´N¯à¥¿±`°Ê§@¤F
clio

TOP

¦^´_ 4# mark15jill

·PÁ¤j¤j¡A³o­Ó§Ú·|¤F¡A¦³ª¦¤å¤F¡A¤§«e¦³¤Hµoªí¹LÃþ¦üªº¡A·PÁ±zªº¦^ÂÐ
clio

TOP

¦^´_  mark15jill

°²¦p¡Aµ{¦¡°ÊºA²£¥Í¤@­ÓUserform, ¦Ó¸Ì­±¦³¤@­ÓListBox¡A³o¼Ë«ç»ò°µ
clio µoªí©ó 2016-3-22 17:23


     ¦³ª¦¤å¤F¶Ü??  ...
   
http://forum.twbts.com/viewthread.php?tid=8858

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

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