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

[µo°Ý] ­Ë¼Æ ¼Æ¦r

[µo°Ý] ­Ë¼Æ ¼Æ¦r

½Ð°Ý¦³ ­Ë¼Æ ¼Æ¦rªº¥\¯à¶Ü?
³æ¤@Àx¦s®æ ±q¼Æ¦r 99 ¸õ ¼Æ¦r 98 97 96 ¤@ª½¸õ¨ì0
         ¤ÏÂФS±q¼Æ¦r 99 ¸õ ¼Æ¦r 98 97 96 ¤@ª½¸õ¨ì0
¤@ª½¤ÏÂÐ
¬õ¦â¦rÅé
ÁÂÁ¤j®a

=MOD(-ROW(A1),100)
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ÁÂÁÂ

¦pªG¬O ³æ¤@Àx¦s®æ ¥i¥H¥Î excel vba
¤@ª½¦b¦P¤@®æ Àx¦s®æ¡A¦Û¤v¸õ°Ê¶Ü?

TOP

¦^´_ 3# momo020608

Sub a()


Do
For s = 1 To 100
[a1] = 100 - s


Application.Wait Now + TimeValue("00:00:01")

Next
Loop

End Sub

¦n¹³·|·í¾÷ µLªk°Ê§@

TOP

¦^´_ 4# momo020608

­n¤@­È¤ÏÂФ£¯à¥Î DO....LOOP

http://forum.twbts.com/thread-15214-1-1.html

­YÅܤƳt«×­n¤p©ó1¬í, ½Ð google search  excel settimer  ¨ú¥N±¼ Application.OnTime

TOP

¦^´_ 1# momo020608

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­ì¨Ó¥i¥H¥Î³o¼Ë¨ç¼Æ¨Ó³]©w¡AÁÂÁÂ~

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD