Ms excel screen updating

Who can help me on this A mroo Bonjour Amroo, You can make a fairly decent progress indicator by doing something like this: -On your userform add two labels each with a different back colour. It just stops the screen from what is known as 'Repainting'. While a Progress bar will actually slow down your code.

Set one of the labels width to 0 and make sure it is the same height and has the same left coordinate as the other one. A better opyion IMO is to put some brief text in the statusbar, eg; Application.

You can design your splash screen however you like.

Bonjour, I have a macro (Macro Import) that imports data on a spreadsheet and execute differents operations on the data. Visible = False Secondly, if you have turned off Screenupdating any 'Progess bar' will not update either.

When I click on a button import file I choose the file, so when I click on start it runs, I hide my worksheet with the code: Application. A userform it shows and I want a progressbar informs the user about the % of work? But this is a much better option as it will speed up the maco execution.

I'll research this a bit more and possibly give it a try.

If your read my previous reply to Alpha Frog, it may be possible to make three different tables for each ledger.

Search for ms excel screen updating:

ms excel screen updating-74ms excel screen updating-1

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “ms excel screen updating”