Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |