running macro at automatic time intervals

T

tjb

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Macro for search tool with multiple entries 2
Losing Data From Formulas When Cell Variable Changes 6
Duplicate Mail Merge Record Every Time 5
Working on birthday "book" for my wife and having layout/editing trouble 0
Problem with Refresh all external data 0
disappearing act 0
Macro/Forumula to SUM values from Sheet that does not always exist 1

Top