Option Explicit Sub macro1() Dim i As Long, lrow As Long Application.
After the macro is finished, the status bar will show as follows – So similarly, you can update the status bar at different parts of the code, so that the user knows what is happening as the macro is running.
Screen Updating Application Property in VBA is used to turn ON/OFF screen updating.
If we set Screen Updating property to TRUE then it turns on the screen updating else turn off the screen updating. In the above syntax Application represents object and Screen Updating is the Property of Application object.
This list gives you a glance at the macro tools in ASAP Utilities. I'm sure you'll find some great time-saving tools such as many others did.Certain vba macros / codes take a long time to run or execute the actions required. Sometimes, there could be one or more macros which cover multiple processes and this status bar will be useful to know at which process, the macro has reached.If you have turned off screen updating using the line Application. We can observe that there is no screen updating till running the macro.Don’t forget to reset the Screen Updating valsue as TRUE at the end of the macro.