Thread
:
.wait for 1/2 a second
View Single Post
#
19
Posted to microsoft.public.excel.programming
crazybass2
external usenet poster
Posts: 167
.wait for 1/2 a second
Tushar,
Well, I guess you do have a point there. <g See what happens when you
type before you think? I guess you Mac folks just have to live with seconds.
"Tushar Mehta" wrote:
In article ,
says...
FYI for those Mac users out there.
I think Sleep is the choice to use when you want to pause for less than a
second.
I realize I am jumping into a discussion I haven't read from the
beginning, but...
Isn't Sleep a *Windows* API?
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Michael,
When I saw this post, looked up the Timer function since I'd never seen it
before. It appears that you are correct, but only for Windows based
machines. The help file for Timer states "In Microsoft Windows the Timer
function returns fractional portions of a second. On the Macintosh, timer
resolution is one second."
FYI for those Mac users out there.
I think Sleep is the choice to use when you want to pause for less than a
second.
Mike
"Michel Pierron" wrote:
Hi Brad,
Why not simply:
Dim T As Single
T = Timer + 1 / 2
While T Timer: Wend
MP
"Brad" a écrit dans le message de news:
...
Thanks for taking the time to read my question.
Is is possible to wait for less than a full second?
Application.Wait Now + TimeValue("00:00:01")
Thanks,
Brad
Reply With Quote
crazybass2
View Public Profile
Find all posts by crazybass2