How to display the progress of a VBA macro in the status bar of Excel

Display a progress status of your macro on the bottom left corner of Excel

Sub My_macro_status() 'To display a status to the user on the bottom left corner of Excel application

Application.StatusBar = "Macro in process: 0%"
'Code
Application.StatusBar = "Macro in process: 50%"
'Code
Application.StatusBar = "Macro in process: 100%"
'Code
Application.StatusBar = False

End Sub

Created by DoMyExcel.com

Customized Excel Solutions starting at $29!

Code syntax: charles.racaud.free.fr