¦p¦ó¨Ï TextBox3.Text ¬°¤@Ó TextBox(i).Text ¨Ó¨Ï¥Î
- ©«¤l
- 550
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 614
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-4-23
|
¦^´_ 4# GBKEE
Dear G¤j¤j & ¦U¦ì¤j¤j
¤p§Ì¹ï±±¨î¶µ(¦p:listbox,textbox.label)ªºÀ³¥Î~ ·Q½Ð±z«ü¾É¤@¤U~
Y¬O§Úªºdata¬ONµ§ (¨C¦¸¤@§ó·s¼Æ¶q¤£¤@)
§Ún¦p¦ó¦bUserForm¤¤²£¥Í¬Û¹ïÀ³ªºLabel
ex.
sheet1 A1:A10 Àx¦s®æªºÈ¬°A~J
SHEET1 ¤¤¦³¹w³]¤@ÓCommandButton1 ÂI¿ï«á·|¸õ¥X¤@ÓUserForm1
¨Ã¦Û¦æ²£¥Í10ÓLabel
Label1.Caption=A
Label2.Caption=B
.
.
Label1.Caption=J
¦bVBA¤¤¬O§_¥i¥H°µ¨ì³o¼Ëªº¥\¯à~ ¦³ÂI°ÊºAªºÅã¥Ü~ |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 550
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 614
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-4-23
|
¦^´_ 8# oobird
ÁÂÁÂo¤j¤jªº±Ð¾É~
§Ú¥ç±N¨äק令
Yuserform1¤¤ªºlabel ¨C¤@±Æ15¦C ¨Ó±Æ¦C
sheet1ªº¸ê®Æ=>¥Î¨Ó§PÂ_label¦@»Ýn±Æ´X¦C
²Ä¤@¶¥¬q¤w¸g¥i¥H¨Ìsheet1ªºdata =userform1¤¤ªºlabel.caption
¥ç¦P®É·s¼Wtextbox
¦AÄ~Äò©µ¦ù¤@Ó°ÝÃD( ¦p¦ó¦A±Nuserform1¤¤ªºlabel & textbox¦s¨ìsheet2)
Y¦buserform1 ¹w³]¤@Ócommandbutton1 ±Nuserform1¤¤label & textboxªº¸ê®Æ
§ì¨ú¨ìsheet2
sheet2.AÄæ ¦s©ñuserform1.label
sheet2.BÄæ ¦s©ñuserform1.textbox |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|