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

[µo°Ý] ¦p¦ó°õ¦æ??

[µo°Ý] ¦p¦ó°õ¦æ??

¤U­±¬O sheet1 ªºµ{¦¡½X
----------------------------------
Private Sub °õ¦æ_Click()
abc
end sub

Private Sub Worksheet_Calculate()
If TimeValue(Now) = TimeValue("09:00:00") Then
abc
End If
end sub
------------------------------------------

abc ¬O¤½¥Îµ{§Ç¡A·í®É¶¡¨ì9ÂI·|¶]¨â¦¸abc??
ÁÙ¬O¥u¶]Private Sub °õ¦æ_Click() ¸Ìªºabc??
©Î¬O¤½¥Îªºabc?

¦^´_ 1# t8899
¨â­Ó³£¤£·|¶]¡A
¨Æ¥ó¥u·|¦b¨Æ¥óIJµoªº®É­Ô¤~·|°õ¦æ¤@¦¸
©Ò¥H _Click() ¤¤ªºµ{¦¡½X¥u¦³¦b°õ¦æ«ö¶s³QÂIÀ»(IJµo¤FClick¨Æ¥ó)¤~·|°õ¦æ¤@¦¸
¦P²z¡A¤u§@ªíªº _Calculate() ¨Æ¥ó¥u¦³¦b¤u§@ªí "­«·s­pºâ" ¤~·|°õ¦æ

©Ò¥HÁöµM§A¸Ì­±¤ñ¹ï®É¶¡¡A¦ý¬O¨S¦³³QIJµoªº¸Ü¡A¬O¤£·|°õ¦æ¤ñ¹ïªºµ{¦¡½Xªº.......

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-11-3 21:42 ½s¿è
¦^´_  t8899
¨â­Ó³£¤£·|¶]¡A
¨Æ¥ó¥u·|¦b¨Æ¥óIJµoªº®É­Ô¤~·|°õ¦æ¤@¦¸
©Ò¥H _Click() ¤¤ªºµ{¦¡½X¥u¦³¦b°õ ...
stillfish00 µoªí©ó 2014-11-3 20:07


§Y¨ÏIJµo®É¶¡ , ¤]¥u¬O°õ¦æ¤½¥Îªºabc  ¤£·|°õ¦æ _Click() ¸Ìªºabc??

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD