MsgBox
 

How can I put a cell value into the messagebox?

Here's my problem :-
I have a huge worksheet with a macro in which I need to disable screen
updating in order to speed up the macro
However I'd like to know the % progress of the whole process and Cell C2
holds this info.

How do I get the value in C2 into the MsgBox , or is there a better way to
do it?

Thanks
Lisa

MsgBox
 

Hi Lisa

A msgbox is not fit for those things. But see John Walkenbach's page
http://www.j-walk.com/ss/excel/tips/tip34.htm

HTH. best wishes Harald

"Lisa" skrev i melding
...
How can I put a cell value into the messagebox?

Here's my problem :-
I have a huge worksheet with a macro in which I need to disable screen
updating in order to speed up the macro
However I'd like to know the % progress of the whole process and Cell C2
holds this info.

How do I get the value in C2 into the MsgBox , or is there a better way to
do it?

Thanks
Lisa