µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Excel VBA ½Ð¯q
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
Excel VBA ½Ð¯q
zz0660
µoµu®ø®§
¥[¬°¦n¤Í
zz0660
·í«eÂ÷½u
UID
38294
©«¤l
50
¥DÃD
15
ºëµØ
0
¿n¤À
75
ª÷¿ú
75
ÂI¦W
1
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
7 ¤p®É
µù¥U®É¶¡
2021-7-21
³Ì«áµn¿ý
2024-6-14
¤¤¾Ç¥Í
©«¤l
50
¥DÃD
15
ºëµØ
0
¿n¤À
75
ÂI¦W
1
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2021-7-21
³Ì«áµn¿ý
2024-6-14
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2021-8-5 00:14
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
Excel VBA ½Ð¯q
¥»©«³Ì«á¥Ñ zz0660 ©ó 2021-8-5 00:15 ½s¿è
2021-8-5 00:15
2021-8-5 00:15
¦³¨âÓ¤u§@ªí¡A¤@ÓAA¡A¥t¤@ÓZZ¡AAA¤u§@ªíªºM1¬°¤U©Ô¿ï³æ(1~10)ªº¼Æ¦r¡A·íAA ¤u§@ªíªºÀx¦s®æO10©ÎP10©ÎQ10©ÎR10(¥|Ó®æ¤l¥u¦³¨ä¤¤¤@Ó·|¦³È)¡A¦³È®É·íM1¤U©Ô¿ï³æ=1®É¡A´N±NȶǨìZZªºK4&K5ªºÀx¦s®æ¡C
·íM1¤U©Ô¿ï³æ=2®É¡A´N±NȶǨìZZªºK6&K7ªºÀx¦s®æ¡A¦p¤U¹Ï©Ò¥Ü¡C
2021-8-5 00:13
2021-8-5 00:13
·íM1¤U©Ô¿ï³æ=3®É¡A´N±NȶǨìZZªºK8&K9ªºÀx¦s®æ¡C
ªþÀÉ®×
QQA.rar
(10.97 KB)
¤U¸ü¦¸¼Æ: 4
2021-8-5 00:14
¼Ó¥D¼ö©«
Excel VBA ½Ð¯q
{½Ð¯q} ¦³¨âÓ¤U©Ô¦¡¿ï³æ¤º®e¸ê®Æ¡A¦p¦ó¥ÎV
Excel VBA ½Ð¯q II
EXCEL½Ð¯q¡A¶}±Ò¯S©w¸ê®Æ§¨¤º¡A¤£¯S©wÀɦWªº
Ãö©óEXCEL VBA ¥~³¡µøµ¡ ¶K¤W°ÝÃD½Ð¯q
{½Ð¯q} ¤U©Ô¦¡¿ï³æ¦³¤º®e¸ê®Æ¡A¦p¦ó¥ÎVBA©Î
Excel VBA ½Æ»s°ÝÃD½Ð¯q
Excel Àx¦s®æ¤@°Ý
Ãö©ó¿n¤À®ø¥¢°ÝÃD¡C
EXCEL Àx¦s®æ¦P¨B°ÝÃD½Ð¯q
¦¬ÂÃ
¤À¨É
singo1232001
µoµu®ø®§
¥[¬°¦n¤Í
singo1232001
(¼öª¯¼y)
·í«eÂ÷½u
UID
27224
©«¤l
354
¥DÃD
5
ºëµØ
0
¿n¤À
387
ª÷¿ú
387
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
vba,vb,excel2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
527 ¤p®É
µù¥U®É¶¡
2017-1-8
³Ì«áµn¿ý
2024-8-2
¡@¼ÊºÙ:
¼öª¯¼y
¤¤¾Ç¥Í
©«¤l
354
¥DÃD
5
ºëµØ
0
¿n¤À
387
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
vba,vb,excel2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2017-1-8
³Ì«áµn¿ý
2024-8-2
2
#
µoªí©ó 2021-8-5 15:13
|
¥u¬Ý¸Ó§@ªÌ
QQA.zip
(20.71 KB)
¤U¸ü¦¸¼Æ: 2
2021-8-5 15:13
¦^´_
1#
zz0660
TOP
singo1232001
µoµu®ø®§
¥[¬°¦n¤Í
singo1232001
(¼öª¯¼y)
·í«eÂ÷½u
UID
27224
©«¤l
354
¥DÃD
5
ºëµØ
0
¿n¤À
387
ª÷¿ú
387
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
vba,vb,excel2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
527 ¤p®É
µù¥U®É¶¡
2017-1-8
³Ì«áµn¿ý
2024-8-2
¡@¼ÊºÙ:
¼öª¯¼y
¤¤¾Ç¥Í
©«¤l
354
¥DÃD
5
ºëµØ
0
¿n¤À
387
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
vba,vb,excel2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2017-1-8
³Ì«áµn¿ý
2024-8-2
3
#
µoªí©ó 2021-8-6 05:55
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
zz0660
¬Q¤Ñ¤Ö¥[¤F¤@Ó ¹LÂo
«¶ÇÀɮפ@¦¸
QQA v1.zip
(17.58 KB)
¤U¸ü¦¸¼Æ: 2
2021-8-6 05:55
TOP
ML089
µoµu®ø®§
¥[¬°¦n¤Í
ML089
·í«eÂ÷½u
UID
3671
©«¤l
2025
¥DÃD
13
ºëµØ
0
¿n¤À
2053
ª÷¿ú
2053
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
Office2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
¦b½u®É¶¡
2405 ¤p®É
µù¥U®É¶¡
2011-3-2
³Ì«áµn¿ý
2024-3-14
ª©¥D
©«¤l
2025
¥DÃD
13
ºëµØ
0
¿n¤À
2053
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
Office2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
µù¥U®É¶¡
2011-3-2
³Ì«áµn¿ý
2024-3-14
4
#
µoªí©ó 2021-8-6 11:01
|
¥u¬Ý¸Ó§@ªÌ
ALT-F11 ¶}±ÒVB½s¿è
¿ï¾Ü ¤u§@ªí1(AA) ¶K¤W¤U¦Cµ{¦¡
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "M1" Then
For Each xV In Range("O10:R10")
If xV > 0 Then
[ZZ!K4:K99] = ""
[ZZ!K4].Offset((Target.Value - 1) * 2).Resize(2) = xV
End If
Next
End If
End Sub
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
TOP
ÀR«ä¦Û¦b :
¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦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¯»µ·