(¤w¸Ñ¨M)vba½Õ¥Î¤u§@ªí¨ç¼Æ¨Ï¥Î¤è¦¡¦³¨î¶Ü?
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
(¤w¸Ñ¨M)vba½Õ¥Î¤u§@ªí¨ç¼Æ¨Ï¥Î¤è¦¡¦³¨î¶Ü?
¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 16:54 ½s¿è
MsgBox Application.WorksheetFunction.value(Left([a1], 4))
½Ð°Ý¤W±ªºµ{¦¡½Xn«ç»ò§ï¤~·|¥¿½T?
·s¼W Microsoft Excel ¤u§@ªí (2).rar (4.12 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
For i = 1 To 11
MsgBox Val(Cells(i, 1))
Next |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 2# GBKEE
½Ð°Ý³o¦UMID¸ò¤u§@ªí¨ç¼Æºâ¬O¦P¤@¦U¶Ü?
¬°¤°»ò¤£¥Î¥[Application? |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 3# oobird
¥Ø«eÁÙ¥u·|¤u§@ªí¨ç¼Æ
val³o¦U¬O²Ä¤@¦¸¬Ý¨ì
¾Ç²ß¤F |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 6# GBKEE
ÁÂÁÂ
Ä~Äò¾Ç²ß |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|