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

[µo°Ý] ½Ð°Ý~©µ¿ð§@·~ ¤£¦æª½±µ¦b¬¡­¶Ã¯¤W³B²z

[µo°Ý] ½Ð°Ý~©µ¿ð§@·~ ¤£¦æª½±µ¦b¬¡­¶Ã¯¤W³B²z

½Ð°Ý~©µ¿ð§@·~ ¤£¦æª½±µ¦b¬¡­¶Ã¯¤W³B²z

Sub ¥¨¶°1()
Application.OnTime Now + TimeValue("00:00:05"), Sheets("¤u§@ªí1").[A2] = 1 '©µ¿ð§@·~ ¤£¦æª½±µ³o¼Ë (¦b ¬¡­¶Ã¯¤W³B²z)
End Sub

' ¥²¶· ­n ³o¼Ë ¥¨¶°1 + ¥¨¶°2  §@·~   ½Ð°Ý~¦³§Oªº¤è¦¡³B²z¶Ü??  ·PÁÂ

Sub ¥¨¶°1()
Application.OnTime Now + TimeValue("00:00:05"), "¥¨¶°2"
End Sub

Sub ¥¨¶°2()
Sheets("¤u§@ªí1").[A2] = 1
End Sub


½Ð°Ý~¦³§Oªº¤è¦¡³B²z¶Ü??  ·PÁÂ
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

Sub ¥¨¶°1()
Application.OnTime Now + TimeValue("00:00:05"), "¥¨¶°1"
Sheets("¤u§@ªí1").[A2] = 1
End Sub

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD