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

[µo°Ý] ¦h­Ó¥¨¶°¡A¦Û°Ê¤Æ°ÝÃD

[µo°Ý] ¦h­Ó¥¨¶°¡A¦Û°Ê¤Æ°ÝÃD

¤j®a¦n:
µ{¦¡¤j­P¤W¬°
Sub µ{¦¡1()
...
Application.OnTime Now + TimeValue("00:00:10"), "µ{¦¡2"
Sub End
Sub µ{¦¡2()
...
Application.OnTime Now + TimeValue("00:00:10"), "µ{¦¡3"
Sub End

Sub µ{¦¡3()
Sub End

°õ¦æµ{¦¡1-X­Ó¥¨¶°¬ù2¤ÀÄÁ

Sub µ{¦¡4()
Sub End

°õ¦æµ{¦¡4¬ù1¤ÀÄÁ

Sub µ{¦¡5()
Sub End

°õ¦æµ{¦¡5¬ù1¤ÀÄÁ

Sub µ{¦¡6()
Sub End

°õ¦æµ{¦¡6¬ù8¤ÀÄÁ

Sub ¦Û°Ê¤Æ()
    µ{¦¡1
    µ{¦¡4
    µ{¦¡5
    µ{¦¡6
Sub End

¬°¤°»ò§Ú§Q¥Î¦Û°Ê¤Æ¥¨¶°¨Ó°õ¦æµ{¦¡1¡B4-6
·Ó¹D²z»¡À³¸Ó·|¬Oµ{¦¡1¶]§¹¤~·|°õ¦æµ{¦¡4¤Î³°Äò°õ¦æµ{¦¡5©M6
¥i¬O°ÝÃD¨Ó¤F
µ{¦¡1¥¼¶]§¹´N°õ¦æµ{¦¡4-5

¹ê¦b§ä¤£¥X­ì¦]
½Ð¦U¦ì¤j¤j«ü±Ð

ÁÂÁ¦U¦ì¤j¤jªº·N¨£¤À¨É¡A§Ú¤j·§¤F¸ÑÅo¡AÁÂÁ¡C

TOP

¯d·N¤@¤UGBKEE¤j¤j»¡ªº

²³æ¨Ó»¡ Application.OnTime ¬O·|Åý¨t²Î¹B¦æ¤è¦V¥Ñ1Åܬ°2
Application.OnTime ...¥H¤Uªº ·|"¥ß§Y"¹B¦æ.

¦pªGµ{¦¡4¤@©w­n¦bµ{¦¡3() «á¹B¦æ, ¨º¨ä¤¤¤@­Ó¤èªk¬O¦bµ{¦¡3()©I¥sµ{¦¡4

¦pªG¥u¬O·Q¨t²Îµ¥«á¤@¤U, ¥i¥H¥Îapplication.wait
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

­Y¬O¦]¬°Application.OnTime ªº Priority À³Àu¥ý©ó¤@¯ëµ{¦¡½X¤§½t¬G
½Ð°Ý¦³¸Ñ¶Ü? ¦]¬°µ{¦¡«Ü¤j¡A¤@§ï§Úªº¸£ ...
spermbank µoªí©ó 2012-10-24 23:15

°õ¦æºüªºÀu¥ý¶¶§Ç¬O¥Ñ¨t²Î¤º³¡¥h±±¨îºÞ²zªº¡A¤@¯ë¦bÀ³¥Î¤W¡A
¨Ï¥ÎªÌ¬OµLªk¾r¶¿ªº¡Aªp¥B¥¦Äݨt²Î±Æµ{±±ºÞ¶µ¡A¦Ó¥Bµ{¦¡4¡B
µ{¦¡5¡Bµ{¦¡6µ¥ªº±Æµ{³£¥i¯à¤ñµ{¦¡1°õ¦æ³B²zªº®É¬qÁÙµu¡C
¥H©¹¦b¹ê°È³B²z¤W¡A³£ºÉ¥i¯à¥h¦Ò¶q¡B»PÁ×°£³o¨Ç§x´o°ÝÃD¡A
°õ¦æ¥¦­Ì®É³£·|¥ýÅý¥D¼Ò²Õ°õ¦æ§¹«á¡A¦A¥h³B²z«áÄòªºµ{¦¡¬q¡C

TOP

­Y¬O¦]¬°Application.OnTime ªº Priority À³Àu¥ý©ó¤@¯ëµ{¦¡½X¤§½t¬G
½Ð°Ý¦³¸Ñ¶Ü? ¦]¬°µ{¦¡«Ü¤j¡A¤@§ï§Úªº¸£³U´N¶Ã¤F¡C

TOP

¦^´_ 4# mark15jill
¦]¬°°õ¦æ¤§µ{¦¡½X¬°¡G
  1. Sub ¦Û°Ê¤Æ()
  2.     µ{¦¡1
  3.     µ{¦¡4
  4.     µ{¦¡5
  5.     µ{¦¡6
  6. Sub End
½Æ»s¥N½X
©Ò¥H¤~·|¦³#1¼Ó¥D©Ò­zªºª¬ªp¤Þµo¡C

TOP

­Y¬O³æ¯Â¥H µ{¦¡»Î±µ¨Ó¬Ý...
    Application.Run "¬¡­¶Ã¯1!¥¨¶°1"
    Application.Run "¬¡­¶Ã¯1!¥¨¶°2"

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# spermbank
Application.OnTime ªº Priority À³Àu¥ý©ó¤@¯ëµ{¦¡½X¤§½t¬G¡C

TOP

¦^´_ 1# spermbank
°ÝÃD¬O¨S¦³¬Ý¨ì§Aµ{¦¡ªº¤º®e,
¥i«ö F8 ¤@¦æ¤@¦æ°õ¦æ Sub ¦Û°Ê¤Æ() §ä¥X­ì¦].

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD