Excel vba status bar screenupdating


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. Here is a pic of the status bar while the macro is running.



How do I let the user know the number of text files processed for example when screenupdating = False???

Also, you can create multiple instances of the Progress Bar simultaneously. They even gave me code snippets to resolve the problem; thank you all.



Excel vba status bar screenupdating comments


  • Screen Updating using VBA in Excel - Excel VBA Templates profil de paulette60

    paulette60

    Screen Updating using VBA in Excel. When you don't want to see your screen follow the actions of your VBA code macro, you can use ScreenUpdating property…