"Please wait" auto-open and close popup box in VBA?

[isabelle.r]

Hello,

I have an Excel file which, when the user activates a macro, does a fair amount of sorting and recalculating. In cases where the sheet contains a lot of information, the operation may take some time, during which it may seem to the user that the file has stopped responding.

I was thinking of a "Please wait, working on data" MsgBox which would pop up when the macro starts, and auto-close when it ends. I looked everywhere online, but can't find a way to make the box not show the "OK" button (I wouldn't want to impose an additional click on the user), and instead just close by itself when the macro has finished working.

Any ideas on how to accomplish this?

Thanks,

-Isa

[nigelog]

Create a userform to display instead of the message box or progress bar. See attached

[KOKOSEK]

I've sort it like this:
Insert nice picture, with message like 'please wait.... data loading/recalculating' or something like this and make it visible=false.

then in your macro:

- show it (visible=true)
- screenupdating = false
- main part of your macro here
- screenupdating = true
- hide it (visible=false)

p.s. straight from one of mine:
refreshing and recalculating around 25-35 seconds, so it displays nice forest view with small info 'Please wait' at the bottom right

Please Login or Register  to view this content.

[isabelle.r]

Thank you all for your great ideas, I'll probably look into creating a simple userform to display a "please wait" message.