no. sorry to say. when one macro is running, it has
command of the CPU. no other actions or interrupt requests
can proceed untill the macro has stopped. You can throw in
a few doevents but that will only free the CPU to do
system events.
so running 2 macros at once is not possible.
as for a timer for the macro, unforumately there is no
timer control built in to excel. you can use the status
bar by adding application.statusbar = "yourmessage" in
your code at various stages to let you know about where
the macro is but that is about it. when done make sure you
set the status bar to nothing.
sorry.
Regards
Frank
-----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

.