Excel vba status bar screenupdating

6854933580_2c8b688306_z

Excel is versatile by itself and VBA makes it even better by allowing us to do our own thing.Most of us use VBA to automate tasks of varying complexity – some macros are executed in a flash, but others take hours to run.I have written a fairly heavy macro that processes text files.Its done with application.screenupdating = false and depending on the number of text files for processing it could take up to an hour (huge text files) to complete.Function is Form Open(By Val Form Name As String) As Boolean 'Declare Function level Objects Dim uf Form As Object 'Set the Function to False is Form Open = False 'Loop through all the open forms For Each uf Form In VBA. How do I show a status bar, progress bar, any kind of information at all really when application.screenupdating = false.You can ask the code to display a status message on the status bar so that the user is informed about the current status of the code.

Hi All, Is there a way to update the Statusbar when Screen Updating = FALSE?While there are users who are happy with just a If you are thinking, “Hey I can see exactly what is going on, why would I need to display messages?”, you may have to consider digging into optimizing your code a little.I will "hide" the screenupdates that the macro performs but in the same sub, show the progress in the statusbar.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.Users can display custom messages on Excel’s status bar when needed, and allow excel to take over after their macro finishes executing.

You must have an account to comment. Please register or login here!