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...o&userid=12480
View this thread:
http://www.excelforum.com/showthread...hreadid=277113