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 <tjb@discussions.microsoft.com> 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?