Dear friends,

I have written many marco commands for an active worksheet with the learn
marco command using Visal Basic. The current time on my worksheet will be
updated automatically.

How can I write another marco command that could activate each of the marco
commands based on certain true condition. e.g. after the passage of every
minute.

Please help.

U¿ytkownik "Dominic Mak" <Dominic napisa³ w
wiadomo¶ci ...
Dear friends,

I have written many marco commands for an active worksheet with the learn
marco command using Visal Basic. The current time on my worksheet will be
updated automatically.

How can I write another marco command that could activate each of the
marco
commands based on certain true condition. e.g. after the passage of every
minute.

Please help.


if you want to run macro in a given period of time try to use
application.ontime + name of your macro

mcg

If you want to read more about Excel's VBA OnTime method, visit Chip Pearson's
site:
http://www.cpearson.com/excel/ontime.htm

Dominic Mak wrote:

Dear friends,

I have written many marco commands for an active worksheet with the learn
marco command using Visal Basic. The current time on my worksheet will be
updated automatically.

How can I write another marco command that could activate each of the marco
commands based on certain true condition. e.g. after the passage of every
minute.

Please help.

--

Dave Peterson