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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

--
Regards,
Tom Ogilvy

"Pedo00ab" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

(m)

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

--
Regards,
Tom Ogilvy

"Pedo00ab" wrote in
message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/



.

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

--
Regards,
Tom Ogilvy

"Dave Northrup" wrote in message
...
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

(m)

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

--
Regards,
Tom Ogilvy

"Pedo00ab" wrote in
message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/



.

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

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


Pedo00ab wrote in message ...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/