Macro - Run automatically every X minutes

[Haim]

I would like that the macro that I build
will run automatically every 3 minutes.

How can I do that?

Thank you.

 

[Frank Kabel]

Hi
you can use the OnTime method. See:
http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Thank you, Frank.

I will try it.

Hopefully it will work.
If not, I will let you know...

Thanks,

Haim.

 

[Bob Phillips]

Look at the Ontime method in VBA Help, and also Chip's page at
www.cpearson.com/excel/ontime.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)