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

How can I do that?

Thank you.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Haim" schrieb im Newsbeitrag
...
I would like that the macro that I build
will run automatically every 3 minutes.

How can I do that?

Thank you.

Thank you, Frank.

I will try it.

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

Thanks,

Haim.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Haim" schrieb im
Newsbeitrag
...
I would like that the macro that I build
will run automatically every 3 minutes.

How can I do that?

Thank you.



.

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)

"Haim" wrote in message
...
I would like that the macro that I build
will run automatically every 3 minutes.

How can I do that?

Thank you.