MsgBox saying Excel is calculating

[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

 

[Tom Ogilvy]

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).

 

[Dave Northrup]

See if this site helps. I have never tried it, but it
seems like it might work for you.

http://www.cpearson.com/excel/Progress.htm

Good luck!

Dave

(e-mail address removed)(m)

 

[BrianB]

Show a text box and remove it when the process is complete ?

Regards
BrianB
==========================================================

 

[Tom Ogilvy]

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

 

[Pedo00ab]

Thanks a lot - It is not working yet, but hopefully in a short while..