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

[µo°Ý] ¥ÎVBAø¹Ï°ÝÃD

[µo°Ý] ¥ÎVBAø¹Ï°ÝÃD

¦U¦ì¤j¤j¤È¦w
¤p§Ì§Ú¥Ø«e¸I¨ì¤@­Óª¬ªpÁ٧䤣¨ì¤èªk¸Ñ¨M
§Ú§Q¥ÎVBAµeXY¹Ï®É µo²{¦³´Xµ§¼Æ¾Ú¤£¬Oµe¦b¥¿½Tªº®y¼Ð¤W­±
´N¹³¤U¹Ïªºµµ¦â½u¬q¤¤ Y­ÈÀ³¸Ó¬O­n±q10~15 ¦ý³£Åܦ¨0¤F
§Úµo²{¦ü¥G¬O¦]¬°Àx¦s®æ¤WÅã¥Üºñ¦â¤p¤T¨¤§Î³y¦¨ªº  
½Ð°Ý³o­Ó°ÝÃD¯à¦bµ{¦¡½X¤º±Æ°£³o­Ó°ÝÃD¶Ü?
ÁÂÁÂ

ÁÂÁÂc_c_lai¤j¤j³o»ò¥Î¤ßªºªþ¤W»¡©ú
¦]¬°­Y§ï¥Îµ{¦¡½X¿é¤J®ÉÁÙ¬O·|µo¥Í¤@¼Ë°ÝÃD
­è­è¬Ýexcel»¡©ú«á¼g¹D"TextBox ªº¹w³]ÄݩʬO Value ÄÝ©Ê¡C"
¤£¹L§ÚÁÙ¬O­nªþµù.value ¤~¦³¥Î

TOP

¦^´_ 8# caponewilliam

TOP

§ÚÁA¸Ñ¤F
§Y¨Ï§Ú¦bÀx¦s®æ¤¤©w¸q¬°¼Æ­È«á ¤§«á¦AÂǥѦۤv³]­pªº¤¶­±§â¼Æ¾Ú®M¤JÀx¦s®æ«á ÁÙ¬O·|Åܦ¨¤å¦r
©Ò¥H¦bµ{¦¡½X¤º©w¸qtextbox¬°value´N¥i¥H¤F
ÁÂÁ¤j®aÀ°¦£^^

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2015-11-26 10:28 ½s¿è

¦^´_ 8# caponewilliam
·í³o¨ÇÀx¦s®æ¬O¥HVBA±N¼Æ¾Ú¿é¤J®É

§A­n´£¨ÑVBA¼Æ¾Ú¿é¤Jªº¹Lµ{¤~¦³¿ìªkÀ°§A§ïµ½¡C¡C¡C
³q±`VBA¿é¤J¨ìÀx¦s®æ¤£·|¯S·NÂন¤å¦r¡C
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

´£¿ô¤@¤U¡G
±N¡e¤å¦r¡f®æ¦¡§ï¬°¡e¼Æ­È¡f®æ¦¡«á¡A¥²¶·­«·s¿é¤J¤@¦¸¼Æ­È¡A¤è¬°¦³®Ä­È¡I
¡e¯ù¸­³J¡f§ï¦¨¡e¥ÕµN³J¡f¡A¯ù¸­³J¤£·|¦Û¤v¥Õ¦^¨Ó¡A­n©ñ·s³J¡ã¡ã

TOP

ÁÂÁ¦U¦ì¤j¤jÀ°¦£
³o¼Ë¤l°µªk ¦bexcel§ó¸Ó´N¥i¥H
¤£¹L·í³o¨ÇÀx¦s®æ¬O¥HVBA±N¼Æ¾Ú¿é¤J®É
´NÁÙ¬O¤@¼Ë·|¥X²{°ÝÃD
½Ð°Ý¬O­n¦bµ{¦¡¤º­×§ï¶Ü?
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2015-11-26 07:39 ½s¿è

¦^´_ 4# caponewilliam
¨Ì·Ó stillfish00¼Ó¥D¡BScott090¼Ó¥D
¥H¤Î GBKEE ª©¥Dªº»¡©ú¡A·í¥i¸Ñ¨M§A
¡u¦³°ÝÃDªº¼Æ¦C¡v¡C

¥ç§Y±N¡uE13¡v¡B¡uE14¡v¡B¡uB5¡v¡B
¡uE4¡vµ¥¥|­ÓÄæ¦ìªº¡yÀx¦s®æ®æ¦¡¡z
(«ö·Æ¹«¥kÁä)±N¡u¤å¦r¡v§ï¦¨¡u¼Æ­È¡v
µM«á§A¦A¨ì¡uE4¡vÄæ¦ì¤º­«·s¿é¤J100¡A
§AÆ[¹î¹Ïªí¬O§_¦³¤FÅܤơC



TOP

¦^´_ 4# caponewilliam
¼Æ¦rªº®æ¦¡¤£­n³]¬°¤å¦r®æ¦¡

   
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ Scott090 ©ó 2015-11-26 06:50 ½s¿è

¦^´_ 4# caponewilliam


    2#Á¿ªº¹ï¡A¤£­n¦s¦¨¤å¦r§Î¦¡
F13 §ï¦¨ = --B5
F14 §ï¦¨ = --E4
E13 ¤Î E14 Àx¦s®æ®æ¦¡§ï¬°¼Æ­È

©ÎªÌ ª½±µ§â B5 ¤Î E4 Àx¦s®æ®æ¦¡§ï¬° ¼Æ­È

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD