running macro at automatic time intervals
 

I have an excel sheet set up to use a web query to refresh with data from a
web page.

I want to have a macro that runs on this sheet every minute, as long as it
is open, to have a message box pop up when specified criteria is entered in a
cell from the web query.

Any suggestions?

One suggestion.

See Chip Pearson's site for the OnTime method in VBA.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben Excel MVP

On Mon, 28 Feb 2005 11:55:04 -0800, tjb wrote:

I have an excel sheet set up to use a web query to refresh with data from a
web page.

I want to have a macro that runs on this sheet every minute, as long as it
is open, to have a message box pop up when specified criteria is entered in a
cell from the web query.

Any suggestions?