¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
¥»©«³Ì«á¥Ñ color790 ©ó 2011-11-11 17:29 ½s¿è
°Ý¤@ӫܲʲLªº°ÝÃD.....(¤£¹L§Ú§Ö³Q·dºÆ¤F)
¥Dn¬O·Q¥Îª©¥DGBKEE ³o¤@¬qµ{¦¡ http://forum.twbts.com/thread-4188-1-1.html
¥u¬O³£µLªk°Ê,©Ò¥H§ä¤F¥H¤U³Ì²³æªºµ{¦¡¨Ó¸Õ¸Õµ²ªG¤]¤£¦æ,
Private Sub Worksheet_Calculate()
Range("b1").End(xlDown).Offset(1) = Range("a1")
End Sub
·N«äÀ³¸Ó¬O[A1]¦pªGÅÜ°Ê,¦bBÄæ·|°O¿ý¤U¨Ó, ¥i¬O¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
µ{¦¡¼g¦b¤u§@ªí1¤]¤£·|°Ê, ThisWorkbook¤]¤£·|°Ê
¬¡¶Ã¯2.rar (10.9 KB)
|
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
観«¸Õ¤@¤U, §Ú¥ÎDDE, ¼Æ¾Ú½T©w·|°Ê, ¦ýBÄæ«o³£¤£·|°Ê
ÁÙ¬O»¡n³]©wþÃä, ¯u©_©Ç |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
¥i¥H¤F.... µ²ªG¯uªº«Ü©_©Ç
¦n¹³n¦b¥¨¶°³]©w¸Ì, ÂI¿ï "±Ò¥Î©Ò¦³¥¨¶°(......) "
¥H«e³£ÂI¿ï "°£¤F¸g¼Æ¦ìñ³¹ªº¥¨¶°¥~,°±¥Î©Ò¦³¥¨¶°" , ¶}Àɮ׫ö±Ò¥Î¥¨¶°´N¥i¨Ï¥Î¥¨¶°
³oÓ©~µM¤£¦æ.....
¤£¹LÁ`ºâ¥i¥Î¤F, ±ß¤@ÂI¦A¨Ó¸Õ¸ÕGBKEEªºµ{¦¡
ÁÂÁ¤j®aªºÀ°¦£, ¦pªG¦³°ÝÃD,¦A³Â·Ð¦U¦ìÀ°¦£¸Ñµª...... ^^ |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
HI~GBKEEª©¥D
è¥Î§A¼gªºµ{¦¡, ¤S¤£·|°Ê¤F
¥i§_³Â·Ð§AÀ°§Ú¬Ý¤@¤U(§Ú¦³×§ï®É¶¡¤Î¤@ÂIÂI¨ä¥Lªº)
¬¡¶Ã¯2.rar (16.12 KB)
|
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
ª©¥D,§Ú¤£¤ÓÀ´
§ÚD1²{¦b¬O³] 10:00:00 PM , B1¬O09:00:00 AM
¥Ñ©ó¬O§ì¥~°êªºDDE©Ò¥H¥Ø«e³£·|°Ê, ¤]³]¥ß¤¤Â_ÂI, ¤]«ö F2 ¦A«ö Enter
¦ý¦bVBAµøµ¡«öF8³£¬O¨ì©|¥¼¶}½L¤U¤@¦æ´N¤S°j°é¤F, ³o¬O¬°¤°»ò? |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
ª©¥D¤£n³o»ò»¡, §AªÖÀ°¦£¤w¸g«Ü¦n¤F....
¥Ñ©ó²{¦b¬O°²¤é¨S¦³DDE¨Ó·½¥i¥Î, §«ô¤@¦A¨Ó§¹¾ãªº¨Ï¥Î¬Ý¬Ý,
¦pªG¥Îª©¥Dªº¤èªk(³]¤¤Â_ÂI,«öF8´ú¸Õ), ·|¦b³o¤@¦æ°±¤î
Tr = Int((Time - startTime) / Time_Step) + 30
´«¦¨¥t¤@¦æOK
Tr = Int((Time - startTime) * 1440) +30 |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
HI~ª©¥D
¤w¸g¥i¥H¥Î¤F, ÁÂÁÂÀ°¦£~
¥t¥~¦A½Ð°Ý¤@¤U(ÁöµMì¨Óªº°µªk¤]¥i¥H)
1.¦pªG¨Ï¥ÎDDE¤Wªº®É¶¡, n«ç»ò°µ¨ì¨C´X¤ÀÄÁ§ì¤@¦¸¸ê®Æ(¦]¬°¦³®ÉÔ·|¸ò¹q¸£ªº®É¶¡¤£¤Ó¤@¼Ë)
DDE®É¶¡®æ¦¡¬OÃþ¦ü¹³134459 --->13:44:59
2.DDE¤@ª½¦b¸õ°Ê,¥i¥H¥Î¨Ï²Ö¿n¶q°O¿ý¶Ü?¤ñ¦p°O¿ý²Ö¿n¤@¤ÀÄÁªº¶R½æ¶q
3.Private Sub Worksheet_Calculate() ¦³¿ìªk¦b¨ä¤¤¤@¨âÓÀx¦s®æµo¥ÍÅܰʤ~IJµovb¶Ü? |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
DDE-1.rar (16.98 KB)
hi~ª©¥D, ¤£¦n·N«ä, ¦³2Ó·Qªk·Q½Ð§AÀ°¦£
1. ®É¶¡¬O·Q¥Hdde¤Wªº®É¶¡¬°¥D,¨C5¤ÀÄÁ(©Î1¤ÀÄÁ) °O¿ý»ù®æ,®É¶¡,³Ì°ª»ù,³Ì§C»ù,¶}©l»ù,µ²§ô»ù¤Î²Ö¿n[G8] & [I8]ªº¶q
2. ¥t¤@Ó·Qªk¬O·Q[G8] & [I8]µo¥ÍÅܤÆ, ¤~°O¿ý®É¶¡,»ù®æ |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
¤Ñ°Ú.....¤Ó·PÁ§A¤F,ª©¥D
¦^®a¦A¨Ó¸Õ¤@¤U, ·P®¦:'( |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 152
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-1-18
|
HI~ª©¥D, ¦A³Â·Ð§A¤@¤U~
²Ä¤@Óµ{¦¡¦b襴¶}µ{¦¡®É, ¤U±³o¤@¦æ·|¦³¿ù»~²£¥Í
If S <> [G8] & [i8] And [G8] & [i8] <> "" Then
¤£¹L¦b°»¿ù«á°±¤î¦A«ö°õ¦æ´NOK¤F,¦A³Â·Ð§A¤@¤U, ÁÂÁª©¥D~ |
|
ªì¾ÇªÌcolor
|
|
|
|
|