Display info/data as Macro runs
Posted on 2003-11-19
In VBA with Excel
Have a macro
It loops thru some cells (hundreds)
Would like to have msgbox/userform or whatever, display some values as it processes the data (w/o user having to press OK, or close the window each time - a status window, if you will)
To simplify the q, I want to have it display something like this "Processing Row Number: RowNo"
Where "RowNo" is the number (integer) of the row it is currently processing.
For RowNo = FirstRow To LastRow
'display a message saying "Processing Row Number: RowNo"
Tried using MsgBox & UserForm but have to press OK or close window each time (hundreds)
Just want it to display the info and move on.