slow down a running macro

[terry down]

I wrote a macro which basically had some large text flashing.
It ran so fast it was over in a couple of seconds.
Is the some like a pause command or for/next statement I can use in between
each colour change to slow this down.

just curious



tezza

 

[J.E. McGimpsey]

Check out the Wait method in VBA help.

 

[Bradley Dawson]

Hoo boy! Slow down VBA! Usually not a request. Also look at Timer and the
Timer example in help.