smanjunath
New Member
Can we show a window in excel where it can reflect that the processor is trying to calculate/ update the sheet with Macros. It does come in bottm right corner, but for ease of use can we show percentage processed in the sheet
Window showing processing status
- Thread starter smanjunath
- Start date
GCExcel
Member
Hi,
Not sure if this is what you are looking for but one method that I use to show that a macro is running, is by updating the status bar shown in the lower left corner in Excel. You need to create a variable used as a counter.
For example, if your macro needs to perform calculation on rows 1 to 10000 and you have a loop, you can included in your loop this line of code :
Application.StatusBar = "Now processing row " & i & "/10000"
or
Application.StatusBar = "Now processing row " & i/10000 * 100 & " %"
where i is your "loop" variable.
At the end of the macro to reset the status bar:
Application.StatusBar = False
Regards.
Not sure if this is what you are looking for but one method that I use to show that a macro is running, is by updating the status bar shown in the lower left corner in Excel. You need to create a variable used as a counter.
For example, if your macro needs to perform calculation on rows 1 to 10000 and you have a loop, you can included in your loop this line of code :
Application.StatusBar = "Now processing row " & i & "/10000"
or
Application.StatusBar = "Now processing row " & i/10000 * 100 & " %"
where i is your "loop" variable.
At the end of the macro to reset the status bar:
Application.StatusBar = False
Regards.