View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
crazybass2 crazybass2 is offline
external usenet poster
 
Posts: 167
Default .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