MsgBox saying Excel is calculating

  • Thread starter Thread starter Pedo00ab
  • Start date Start date
P

Pedo00ab

I have build a workbook with dropdown boxes and large lists. When
changing a variable in a dropdown box, due to the huge amount of data,
Excel calculates for a while.

I am looking for a way, to make a msgbox appear saying "Please wait -
Excel is calculating", while the calculation goes on.

Thanks a lot
Peter
 
You should be getting a message in the status bar showing the percent done.

If you put up a msgbox, then nothing will happen while it is displayed. So
this won't work.

You might be able to put up a Userform and have code in the activate event
of the form execute a calculate command. (I assume calculation is set to
manual and the caculation is kicked off with a button).
 
Show a text box and remove it when the process is complete ?

Regards
BrianB
==========================================================
 
The concept is OK, but there is no way to get in the middle of a calculate
to see how long it will take - so you can't update the progress bar
 
Back
Top