Chip Pearson has more to say on the subject of procedure timing.
Take a look at Using Windows Timers ...
http://www.cpearson.com/excel/ontime.htm
--
Jim Cone
San Francisco, USA


"JLGWhiz"

wrote in message
You are right Jim. That is my dilema. The Wait function only allows a
minimum of one second for and interval within a loop. Anything less than
that has to be done on a form like an animation. I was hoping someone had
come up with a way to write a function similar to using Application.Wait ()
that could return the interval time in milliseconds.
The code that Dave Gave me can't be plugged into a loop as an interval, it
will simply allow the loop to run until the On Time mark is reached. My
objective is to make certain loops that change text or colors (any visual
effect) run slow enough for the human eye to perceive, but fast enough that
it gives a motion effect. I am using these loops in a novelty program that I
have written in VBA with Excel as the base. The program runs fine. It just
needs a little visual enhancement.
Thanks to both of you for your assistance.
JLG