Thread: Hi Trevor :)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
peteriks[_8_] peteriks[_8_] is offline
external usenet poster
 
Posts: 1
Default Hi Trevor :)


GOOD :)
This example displays a message indicating whether 3seconds hav
passed.
If Application.Wait(Now + TimeValue("0:00:03")) Then
MsgBox "Time expired"
End If

BUT
how to tell to macro to display this message for period of 3 second
(even less than 1 seocnd)

Thank's
Peterik

--
peterik
-----------------------------------------------------------------------
peteriks's Profile: http://www.excelforum.com/member.php...fo&userid=3701
View this thread: http://www.excelforum.com/showthread.php?threadid=57295