Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wait Seconds and Tenths
JLG, I think I figured it out. Help says that in Windows, Timer
returns fractional seconds, and on the Mac the Timer resolution is 1 second. Since I'm on a PC, I decided to combine the seconds and the fractional part into one mixed number. This SEEMS to work! Cheers, James Sub myTest() TestTimer 0.5 End Sub Sub TestTimer(myWait As Single) Dim start start = Timer ' Set start time. Do While Timer < start + myWait DoEvents ' Yield to other processes. Loop End Sub JLGWhiz wrote: I asked this question a few weeks ago and could not find anyone who knew how to get less than one second. Hope you have better luck, but I don't think you will find the answer in VBA. "Zone" wrote: I want to put a whole number in a cell, say A1, to represent seconds, and another whole number in a cell, say B1, to represent tenths (or hundredths) of a second. How do I get my macro to pause for this amount of time? Please specify type of any variables! Thanks, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
Macro wait 30 seconds then Complete the Macro | Excel Discussion (Misc queries) | |||
Display MsgBox wait for 10 seconds then click on yes automatically | Excel Programming | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) |