Excel Vba inputbox ¨Ì§Ç±a¤JBÄæÀx¦s®æ, ·Ð½Ð¤j®v«üÂI°g¬z!?
- ©«¤l
- 19
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-13
- ³Ì«áµn¿ý
- 2017-4-11
|
Excel Vba inputbox ¨Ì§Ç±a¤JBÄæÀx¦s®æ, ·Ð½Ð¤j®v«üÂI°g¬z!?
¦pªþ¹Ï, §Ú¯à°÷±N¿é¤JªºÈ(¦r¦ê)¨Ì§Ç±a¤JBÄæ¦ì¤¤¶Ü?¨ÒB9>B10>B11
Private Sub sheet1_Click()
imputbox("½Ð¿é¤JProject name¡G")
Sub end
|
|
|
|
|
|
|
- ©«¤l
- 19
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-13
- ³Ì«áµn¿ý
- 2017-4-11
|
ã¤j§Ú²×©óµ¥¨ì±zªº¦^ÂФF, §Ú¦bª¾ÃÑ®a¤@ª½¦b´Á«Ý±zªº¦^ÂÐ, ¤]«D·PÁ±z¯à©âªÅ¦^µª!!!!!!!!
¤pªº¦í¦b®ç¶é¤£¾å±o±z¬O§_¦³¶}¯Z±Â½Ò¤§Ãþªº½Òµ{?
¦³ÓºÃ´b, ¤£¾å±o¯à§_©w¸q±a¤JªºÄæ¦ì¥ÑB9¶}©l©O? |
|
|
|
|
|
|
- ©«¤l
- 19
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-13
- ³Ì«áµn¿ý
- 2017-4-11
|
¦^´_ 4# ã´£³¡ªL
ã¤j¤pªº¦³ºa©¯Åý±z¸Ñµª¯uªº·P®¦¨ì¤Åé§ë¦a¤F, ¹ï©óVBÅÞ¿èÁÙ¤£¤Ó¼ô±xªº§Ú¤Sn¦bªÀ·|¤W¥Í¦s¥u¦n¶R¥»®Ñ¦Û¾Çݪ¦¤å!!!!
B9¬°²Ä¤@®æ¶ñ¤JªºÄæ¦ì, «á±¨Ì§Ç±a¤JB10 B11 B12ªºÄæ¦ì, 즳ªº¸ê®Æ»Ýn«O¯d !
°²³]B9 B10 B11¦³¸ê®Æªº¸Ü´N©¹B12±a¤J! |
|
|
|
|
|
|
- ©«¤l
- 19
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-13
- ³Ì«áµn¿ý
- 2017-4-11
|
BOSS.zip (47.61 KB)
¦^´_ 6# ã´£³¡ªL
«D±`·PÁÂã¤jªº«ü¾É,
¤£¾å±o¬O¤£¾A¤pªº»â®©¤O¤Ó®t,¦pªGT¬°inputboxªºÅܼÆ
1.§Ú¨S¿ìªkµ²¦X§Ú²{¦³ªºcodeª½±µ§âAcoustic Engineer (Pearl)·j´MªºÈ§ï¦¨inputboxªºTªºÅܼƶÜ?
2.Cells(Rows.Count, "B").End(xlUp)(2) ¸Ó¦Cªºcode§Ú¦³ÂI¤£²z¸Ñ¬°¦ó¦p¦¹¼¶¼g? |
|
|
|
|
|
|
- ©«¤l
- 19
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-13
- ³Ì«áµn¿ý
- 2017-4-11
|
¦^´_ 8# ã´£³¡ªL
ÁÂÁÂã¤j, ±z«ü¾É§Úªº¤è¦¡¥i¥H¦¨¥\¹B¦æ!!!!:) :) |
|
|
|
|
|
|