Look in help at DoEvents


-----Original Message-----

Hi, And Many Thanks in advance!

I would like to add a timing range and /or Shape, button
to show for a
while "10 Seconds" the time going down
and while going down be able to press one other button,
and run the
macro attached to it.
Is it Posibble??


My Try:
For X = 10 To 0 Step -1
Activesheet.Buttons("Time").Caption = X
'or Range("A1").Value=X
Application.Wait Now + TimeValue("00:00:01")
Next X


'so when I am showing this timing going down, be able to
press a few
other macros.

Am I missing anything, is it possible??
Do I have to attach any doevents?? do loop??
Any Idea?

Thanks


--
0000_AAAA_0000
----------------------------------------------------------
--------------
0000_AAAA_0000's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=12480
View this thread:
http://www.excelforum.com/showthread...hreadid=277113

.