activate marco command

[Guest]

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.

 

[Macgru]

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

 

[Dave Peterson]

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