ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Àɮ׶}±Ò¦Û°Ê§ó·s¥~³¡³s½u¸ê®Æ¡A¦p¦ó¦b§ó·s§¹¦¨«á¦Û°ÊIJµo¥¨¶°¡H

[µo°Ý] Àɮ׶}±Ò¦Û°Ê§ó·s¥~³¡³s½u¸ê®Æ¡A¦p¦ó¦b§ó·s§¹¦¨«á¦Û°ÊIJµo¥¨¶°¡H

¦U¦ì¥ý¶i¦n
        ÁöµM¤w¸g¹Á¸ÕµÛ¦b°Q½×°Ï¤¤·j´MÃþ¦ü¥¨¶°Ä²µoªº©«¤l¡A¦ý¦ü¥GµLªk¸Ñ¨M§Úªº°ÝÃD...
        ¦pÃD¡A§ÚªºÀɮ׶}±Ò·|¦Û°Ê§ó·s¥~³¡³s½u¸ê®Æ¡A§Ú§Æ±æ¦b¥~³¡¸ê®Æ§ó·s§¹¦¨«á¦Û°ÊIJµo¥¨¶°¡A
        ¥Ñ©ó¥~³¡¸ê®Æ§ó·s«á¡A¤u§@ªí¤¤ªº­ì©l¸ê®Æ¦C·|§ïÅÜ¡A¦]¦¹¦³¹Á¸Õ¦b¤@­Ó©T©wªºÀx¦s®æ¨Ï¥Î COUNTA¡A
        ¨Ã§Q¥Î Private Sub Worksheet_Change(ByVal Target As Range) ³oºØ¤è¦¡¨ÓIJµo¡A
        ¦ý´ú¸Õ«áµo²{¡AÀɮ׶}±Ò¸ê®Æ§ó·s§¹«á¡A¸ÓÀx¦s®æªº¼Æ¦r¦]¬°¸ê®Æ¦C¼Æ§ïÅܤw¸g¦P¨B§ïÅܤF¡A¦ý«o¨S¦³Ä²µo¥¨¶°...
        ¥u¦³·í§ÚÂù«öÂI¿ï¸ÓÀx¦s®æµM«á«öEnter«á¡A¤~¯à¥¿±`IJµo¥¨¶°¡C
        ¬O§_¦³¬Æ»ò»yªk¥i¥Hª½±µ±µÄò¥~³¡¸ê®Æ§ó·s§¹¦¨«á¦Û°ÊIJµo¥¨¶°¡H
        ©ÎªÌ¦p¤W­z¨Ï¥ÎCOUNTAªº¤è¦¡¡A¦ýIJµo»yªk»Ý­n½Õ¾ã¡H
        ¥H¤WºÃ°Ý¦A½Ð¥ý¶i¨ó§U¸Ñ´b¡A·P®¦¡I
JS

¦^´_ 1# jsleee


    ÁÂÁ«e½úµoªí¦¹¥DÃD
«á¾Ç¤]«Ü·Q¾Ç«e½úªº±¡¹Ò±Ô­z°ÝÃD»P¸Ñ¤è¬ÛÃöª¾ÃÑ,¤è«K´£¨Ñ½d¨ÒÀɮ׶Ü?
½×¾Â«Ü¦h¼F®`ªº«e½ú¥i¥H«Øij¸Ñ¨M¤è®×!
¦ý¬O¦³´£¨Ñ½d¨ÒÀɪº³Ì¦³¾÷·|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 1# jsleee


¦pªG¬Odde
¦b¥ô¤@Àx¦s®æ¥Î­Ó=¸¹ §â®É±`ÅÜ´«ªº³£¥á¶i¨Ó¨Ã¥[°_¨Ó  
¥Î&°_¨Ó¤]¥i¥H¸Õ¸Õ
µM«á
Private Sub Worksheet_Calculate() ¥Î³o­ÓIJµo

TOP

¦^´_ 2# Andy2483


±z¦n¡A¦]ÀÉ®×¥~³¡³s½u¸ê®Æ¬°¤½¥q¸ê®Æ®w¡A¦]¦¹¤£¤è«K´£¨ÑÀɮסA³y¦¨¤£«K½Ð¨£½Ì¡C
JS

TOP

¦^´_ 3# singo1232001

·PÁ±z´£¨Ñ¤è¦V¡Aªì¨B´ú¸Õ·|³y¦¨ÀWÁcªº­«½ÆIJµoªº±¡ªp¡A
¦]«æµÛ³B²z¨ä¥L¨Æ¡A¥ý¼ÈÀÁ¡A¦£§¹«á¦A«ùÄò´ú¸Õ¬Ý¬Ý¡A
·PÁ±z
JS

TOP

¦^´_ 5# jsleee


    ¬Ý§A­n¥D°ÊÁÙ¬O³Q°Ê

¥D°Ê­p®É´N¤£¾a¨Æ¥ó¤F

©w®É°õ¦æ.zip (16.07 KB)

TOP

¦^´_ 6# singo1232001


   Thisworkbook¤º ¦³¤@¬q¥¨¶°

Private Sub Workbook_Open()
On Error Resume Next
Sheets("±Ò°Ê¤¤").Name = "¤w°±¤î"
Sheets("±Ò°Ê¤¤").Tab.Color = 255
On Error GoTo 0
End Sub

³o¨Ç§R±¼  §Ú§ï§¹§Ñ¤F§R

TOP

try .......

Private Sub Worksheet_Calculate()

End Sub

TOP

1) Àɮ׬O³sµ²¥~³¡Àɮתº¤½¦¡? ©Îdde?
2) ¤½¦¡­È¦³ÅÜ°Ê »P §ó·s¬O§_§¹¦¨ ¬O¤£¦P·§©À
3) ¥ÎWorksheet_Calculateªº¸Ü, ¦pªG¤½¦¡¦³«Ü¦h­Ó, ¨º¥i¯à³y¦¨ÀWÁcIJµo
4) °£¤F³o­ÓÀÉ®×, ¬O§_¥i¯à¦b³oÀɮר䥦¤u§@ªí¾Þ§@? ¬Æ©Î¦P®É¶}±Ò¨ä¥¦ÀÉ®×¾Þ§@?

TOP

³o©«¤l¦³´X­Ó½d¨ÒÀÉ, °Ñ¦Ò¬Ý¬Ý
http://forum.twbts.com/viewthread.php?tid=15062

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD