Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trevor - Round Up/Down ? | Excel Worksheet Functions | |||
Thanks Trevor Shuttleworth | Excel Programming |