Hi Trevor :)
 

So far so good
I hope You can do something about it
For selected period of time (2 sec or less) on the screen must be shown
specific text. Text is written on the Excel sheet and can be changed if
necessary.
Excel4 has that kind of thing = Wait(Now()+0.00005)
Simple as that :)
Please, can You


--
peteriks
------------------------------------------------------------------------
peteriks's Profile: http://www.excelforum.com/member.php...o&userid=37011
View this thread: http://www.excelforum.com/showthread...hreadid=572955

Hi Trevor :)
 

VBA has a wait function as well. See help in the VBE.

--
Regards,
Tom Ogilvy


"peteriks" wrote:


So far so good
I hope You can do something about it
For selected period of time (2 sec or less) on the screen must be shown
specific text. Text is written on the Excel sheet and can be changed if
necessary.
Excel4 has that kind of thing = Wait(Now()+0.00005)
Simple as that :)
Please, can You


--
peteriks
------------------------------------------------------------------------
peteriks's Profile: http://www.excelforum.com/member.php...o&userid=37011
View this thread: http://www.excelforum.com/showthread...hreadid=572955

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