Hello,

I've created an Excel workbook with a couple of different worksheets. One worksheet allows a user to provide a date range by selecting a begin date and end date from a Microsoft Date and Time Picker 6.0 (SP4). There is one control for the begin date and one for the end date. On this same worksheet there is a button named "Run" that has a macro attached to it that executes the query then switched to another sheet which I will call "search results."

Rather than executing the query and switching immediately to the search results worksheet, I would like for a message to be displayed that says that the query is running then switch to the search results page once the query has finished running.

When a user would run a query from this workbook, I don't want them sitting there wondering why the search results worksheet is blank so that is why I would like the macro to know when the query is done executing. Any ideas on how I can do this?

Keep in mind that I do everything codeless, but if you have a suggestion that uses code, I can try to decipher it.