µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ¿ï¶µ«ö¶s
1
2
3
¤U¤@¶
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¿ï¶µ«ö¶s
Michelle-W
µoµu®ø®§
¥[¬°¦n¤Í
Michelle-W
·í«eÂ÷½u
UID
20679
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ª÷¿ú
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
213 ¤p®É
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
¤¤¾Ç¥Í
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2016-8-22 13:18
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¿ï¶µ«ö¶s
¥Ø«e¤S¦³¥t¤@Ó¤u§@¤Wªº»Ý¨D¡A»Ýn½Ð¦U¦ì«e½ú¨ó§U«üÂI
¦Û°Ê¶ñº¡Àx¦s®æªº¤è¦¡¡A¦b¥ý«e¤å³¹¦³°Q½×¨ì
¦ý¤p©fÁÙ»Ýn¼W¥[´XÓ¥\¯à...
sheets("¿ï¶µ¹w¯d") ¤º¦³´Xӿﶵ¡A«h¦bsheets("¿ï¾Ü")ªº©ïÀY¦CÅã¥Ü´XÓ
¨Ã¥B¤U±¶ñº¡¿ï¶µ«ö¶s(¯à§_°µ¨ì¥u¯d¤@ӿﶵ¡A¤£n«á±ªºoptionªº¤å¦r?)
³Ì«á¦bsheets("²Îp")ªº¶±¡A¥i¥H¶i¦æ¤ÀÃþ²Îp¼Æ¶q?
¤£¦n·N«ä¡A³o¦¸°ÝÃD¦³ÂI¦h...QQ"
¿ï¶µ«ö¶s.rar
(53.49 KB)
¤U¸ü¦¸¼Æ: 13
2016-8-22 13:10
¼Ó¥D¼ö©«
Listbox¨ú¸ê®Æ°ÝÃD
§P§O«½Æ«á¡A¨Ì·Ó±ø¥ó§R°£
§ì¨ú¿z¿ï«áÀx¦s®æ¤º®e¦Ü¹ïÀ³ªº¤u§@ªí
¦p¦ó¦bºô¶·j´Mµ²ªG«á¡A¦A«ö®É¶¡«ö¶s
VBA ¶W³sµ²ºÃ°Ý
Ãö©ó·s¼W¸ê®Æªº¤ñ¹ï
¤U©Ô¦¡¿ï³æ³sµ²¿z¿ï¥\¯à
Excel vba ¿ý»s¥¨¶°°ÝÃD
¨ú¦r¦êºÃ°Ý
¸ê®Æ½Æ»s¶K¤Wªº°ÝÃD
¦¬ÂÃ
¤À¨É
lpk187
µoµu®ø®§
¥[¬°¦n¤Í
lpk187
·í«eÂ÷½u
UID
20047
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ª÷¿ú
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
892 ¤p®É
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
°ª¤¤¥Í
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
2
#
µoªí©ó 2016-8-22 19:29
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
Michelle-W
½Ð¸Õ¬Ý¬Ý¡A¬O¤£¬O§Anªº¡A¤]¤£ª¾¹D¹ï¤£¹ï¡I
¿ï¶µ«ö¶s.rar
(92.86 KB)
¤U¸ü¦¸¼Æ: 15
2016-8-22 19:29
TOP
lpk187
µoµu®ø®§
¥[¬°¦n¤Í
lpk187
·í«eÂ÷½u
UID
20047
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ª÷¿ú
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
892 ¤p®É
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
°ª¤¤¥Í
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
3
#
µoªí©ó 2016-8-22 19:53
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
Michelle-W
§Ú¦h¼g¤F¤@¦C¥N½X¡A¥i¯à¤£¬O§A»Ýnªº¡A¥i¥H§â¥¦§R°£
.Cells(ro, c.Offset(, 2).Column) = 1
TOP
Michelle-W
µoµu®ø®§
¥[¬°¦n¤Í
Michelle-W
·í«eÂ÷½u
UID
20679
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ª÷¿ú
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
213 ¤p®É
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
¤¤¾Ç¥Í
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
4
#
µoªí©ó 2016-8-23 08:21
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
lpk187
¥¿¬O§Ú¤u§@¤Wªº»Ý¨D~~^^
¥t¥~½Ð°Ý¤@¤U¡A·ísheets("¿ï¾Ü")·s¼W¤Hû¸ê®Æªº®ÉÔ
¶ñº¡¿ï¶µ«ö¶s°õ¦æ«á¡A·|¥þ³¡§ó·s¡AÂл\¹L¥ý«e¤w¿ï¾Üªº
³oÂI¦³¿ìªkקï¶Ü^^""
TOP
Michelle-W
µoµu®ø®§
¥[¬°¦n¤Í
Michelle-W
·í«eÂ÷½u
UID
20679
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ª÷¿ú
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
213 ¤p®É
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
¤¤¾Ç¥Í
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
5
#
µoªí©ó 2016-8-23 11:57
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ Michelle-W ©ó 2016-8-23 12:00 ½s¿è
¦^´_
2#
lpk187
½Ð°Ý³o²Õµ{¦¡½X¤HûÄæ»P½s¸¹Äæ¬O§_¦³¦r¼Æªº¨î?
«Ü®e©ö¥X²{¿ù»~1004
³o¬O¬°¤°»ò§r? §Ú±qµ{¦¡½X¬Ý¤£¥X¨Ó¦³³o¼h¨î...
¦³¤èªk¥i¥H¸Ñ°£¶ÜQQ
¤U¸ü
(9.05 KB)
2016-8-23 11:55
TOP
lpk187
µoµu®ø®§
¥[¬°¦n¤Í
lpk187
·í«eÂ÷½u
UID
20047
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ª÷¿ú
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
892 ¤p®É
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
°ª¤¤¥Í
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
6
#
µoªí©ó 2016-8-23 13:59
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ lpk187 ©ó 2016-8-23 14:05 ½s¿è
¦^´_
5#
Michelle-W
ª«¥ó¤Ó¦h¡A¦ûªº°O¾ÐÅé¤]¬Û¹ï¦h¡A·|¼vÅT¨ì¾ãÅ骺°õ¦æ¡A©Ò¥H·|²£¥Í¿ù»~
«Øij§A¥i¥H¥Î¨ä¥L¤èªk¨Ó³B²z¦P¼Ë°ÝÃD¡A¦Ó¤Ö¥ÎOptionButton
¨Ò¦p¡G¨Ï¥Î¤u§@ªí¨Æ¥óWorksheet_SelectionChange¨Ó¨ú¥Nª«¥óOptionButtonªº¨Ï¥Î
¤]·|±o¨ì¬Û¦Pªº®ÄªG
TOP
Michelle-W
µoµu®ø®§
¥[¬°¦n¤Í
Michelle-W
·í«eÂ÷½u
UID
20679
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ª÷¿ú
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
213 ¤p®É
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
¤¤¾Ç¥Í
©«¤l
63
¥DÃD
13
ºëµØ
0
¿n¤À
122
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
office2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-4-22
³Ì«áµn¿ý
2019-7-19
7
#
µoªí©ó 2016-8-23 14:32
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
6#
lpk187
§Ú¯à©ú¥Õ¦û¥Î°O¾ÐÅé¦h
¦ý§Ú·Q¤£¥X§ó¦nªº¤è¦¡Åý¨Ï¥ÎªÌ¥h¿ï¾Ü
½Ð°Ý±z¯àµy·L¥Î§Ú³o¦¸ªº°ÝÃD°µÓ¥Ü½d¶Ü?
SelectionChangeªº³¡¥÷
¦b¦¹·PÁÂQQ
TOP
ã´£³¡ªL
µoµu®ø®§
¥[¬°¦n¤Í
ã´£³¡ªL
·í«eÂ÷½u
UID
13768
©«¤l
2831
¥DÃD
10
ºëµØ
0
¿n¤À
2887
ª÷¿ú
2887
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
¦b½u®É¶¡
2105 ¤p®É
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-5
ª©¥D
©«¤l
2831
¥DÃD
10
ºëµØ
0
¿n¤À
2887
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-5
8
#
µoªí©ó 2016-8-23 14:47
|
¥u¬Ý¸Ó§@ªÌ
SelectionChange ®e©öµo¥Í»~IJ, ¥i§ï¥ÎBeforeDoubleClick,
³Ì¦nÁÙ¬O¨Ï¥Î¤U©Ô²M³æ, ¹ï¸ê®Æ²Îp¤Î¿z¿ï¤]¸û¦X¾A!
TOP
jackyq
µoµu®ø®§
¥[¬°¦n¤Í
jackyq
·í«eÂ÷½u
UID
21301
©«¤l
319
¥DÃD
6
ºëµØ
0
¿n¤À
309
ª÷¿ú
309
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
2k
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
93 ¤p®É
µù¥U®É¶¡
2015-6-24
³Ì«áµn¿ý
2024-4-27
¤¤¾Ç¥Í
©«¤l
319
¥DÃD
6
ºëµØ
0
¿n¤À
309
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
2k
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2015-6-24
³Ì«áµn¿ý
2024-4-27
9
#
µoªí©ó 2016-8-23 14:50
|
¥u¬Ý¸Ó§@ªÌ
¤j¤j¥i¥H¥Î ¡´¡³ + SelectionChange ¥h°°¸Ë¦¨ option
TOP
lpk187
µoµu®ø®§
¥[¬°¦n¤Í
lpk187
·í«eÂ÷½u
UID
20047
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ª÷¿ú
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
892 ¤p®É
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
°ª¤¤¥Í
©«¤l
552
¥DÃD
3
ºëµØ
0
¿n¤À
578
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-2-8
³Ì«áµn¿ý
2024-7-9
10
#
µoªí©ó 2016-8-23 15:38
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
7#
Michelle-W
¸Õ¸Õ¬Ý
¤£¥u¥u¿ï¨ú¤@ÓÀx¦s®æ¡A¤]¥i¥H¤@¦¸¿ï¨ú¤@ÓÄæ¦ì¡A¦ý2ÓÄæ¦ì¥H¤W´N¤£¦æ¤F
¿ï¶µ«ö¶s(«D¿ï¾Ü«ö¶s).rar
(54.71 KB)
¤U¸ü¦¸¼Æ: 8
2016-8-23 15:35
TOP
ÀR«ä¦Û¦b :
¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
1
2
3
¤U¤@¶
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·