MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Message Box


Posted by John Knight on January 31, 2001 1:24 AM

I have a large spreadsheet which is carrying out calculations and querying a remote SQL database.
During the somewhat lengthy calculate time, I want to flash a box up informing the user that the sheet is calculating, with a message such as "Please wait.....sheet calculating"

Is this possible please?


Posted by JAF on January 31, 2001 2:12 AM

The easiest way is to use the status bar.

To ensure that the StatusBar is visible, use the line:
Application.DisplayStatusBar = True

To display your message, use the line:
Application.StatusBar = "Calculating...Please Wait"

At the end of your macro you will need to "reset" the status bar with the line:
Application.StatusBar = ""

There are more complicated methods of displaying progress bars (search the site for these), but in most cases, the above will do nicely.


JAF

Posted by John Knight on January 31, 2001 4:45 AM

Thanks very much, I'll give that a go.
If I wantedf something more complex, can you suggest where I might find it, I tried searching this site for "Progress bars", and nothing came up?

Posted by JAF on February 07, 2001 8:52 AM

Almost there!

If you do a search for "PROGRESS" this will give you the pointers you need.


JAF Thanks very much, I'll give that a go.