![]() ![]() In this example, I am just showing which function is running. StatusBar is a property of Application object that takes text as input. VBA Code to display messages on Status Bar of Excel Application.StatusBar = "Message" You can display stages of your Marco on the status bar or use it as progress bar. You can use a status bar of excel to get information from Excel without interfering execution of code. If you don’t know where is the status bar in excel, here it is: But due to this, you don’t get to know what is going on in your code. When your VBA code is lengthy and you do several tasks using VBA, you often disable the screen update so that you don’t see that screen flickering. The status bar in excel can be used as a code monitor. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |