Excel 2000 - Pause? Timer? ??? Macro 1

[Freckles]

I need to flash a message on the screen for a short length of time (just enough to read the message) when a macro is run. So I am putting the message into Word Art, then deleting it. BUT how do I pause between the drawing and the deleting so that the Art can be read?

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.

 

[Jorgandr]

you need to use the Application.wait command

ex:
code creates wordart

Newhour = Hour(now())
NewMinute = Minute(now())
NewSecond = Second(now()) + 10
'specifies how long application is to wait
waittime = TimeSerial(newHour, newMinute, newSecond)

Application.wait waittime

code deletes wordart

 

[Freckles]

Perfect! Thanks!!!!

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.