Make label visible once macro finishes run

Hi Gurus,

In my spreadsheet I have 6 macros that do what I need. All 6 macros are running in a sequence and take a minute to complete. What I am trying to achieve here is something like a Completion Status message while user waits for all macros to complete. So I have created a modeless userform with two columns of labels on, 6 labels in each column. First (left) column of labels represent my 6 macros (tasks), and the right column labels are labeled "OK". Those "OK's" are set to visible = False, and I want those "OK's" to go visible = True (one by one) whenever each task has been completed.

How do I achieve this? All 6 macros are called by a single button click.

Any help will be much valued and appreciated!

Hy cytop, you have just broken the world record of the time in responding!

Your suggestion is pretty obvious and I have tried this already but it didn't work. I spent all day yesterday trying LabelcontrolName.Visible = True (without UserformName in front) but failed.

It did work, thanks for your time!

Also, how would I make label caption variable, say when macro starts, label caption is "In progress", when macro completes then it goes to "OK"?

Please Login or Register  to view this content.

After making sure it is visible to start with...

(Still willing to bet you are going to say they do not update - answering specific questions about existing controls like this is guesswork without seeing a copy of the workbook)

I was about to say it didn't work, but forgot to put Userform1.Repaint after the code. All good now, works. Thanks a lot!