| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A fun but not essential problem...
Does anyone have any idea how to make excel wait for
fractions of a second. I reckon you will need an API call since Now() only returns whole seconds. I have absolutely no idea how to go about it so any assistance would be much appreciated. Nick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A fun but not essential problem...
If exact timing is not essential, just add a Do loop that does nothing,
and adjust the number of iterations to achieve roughly the right time. Jerry Nick wrote: Does anyone have any idea how to make excel wait for fractions of a second. I reckon you will need an API call since Now() only returns whole seconds. I have absolutely no idea how to go about it so any assistance would be much appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A fun but not essential problem...
Good point - I only asked for a timing function because I
wanted to link the wait time to a control but I suppose I can just link the number of iterations to the control. Cheers - that should sort it -----Original Message----- If exact timing is not essential, just add a Do loop that does nothing, and adjust the number of iterations to achieve roughly the right time. Jerry Nick wrote: Does anyone have any idea how to make excel wait for fractions of a second. I reckon you will need an API call since Now() only returns whole seconds. I have absolutely no idea how to go about it so any assistance would be much appreciated. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A fun but not essential problem...
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Function ADelay(mSecs) Sleep mSecs End Sub Adelay 500 waits half a second -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Nick" wrote in message ... Does anyone have any idea how to make excel wait for fractions of a second. I reckon you will need an API call since Now() only returns whole seconds. I have absolutely no idea how to go about it so any assistance would be much appreciated. Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| frustrated in backing up essential autofill and autocorrect files | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Hybrid Mode
