Excel VBA Hide all opened userforms

Question

I have a medical userform that a clinician will be using. There are several buttons to allow them to navigate to different forms. I'm currently using a Sub that does several checks to see if the forms are visible and if so, don't be. But that's not very friendly for adaptation.

Is there a call I can make to hide all currently open visible forms. Or, cycle through all currently opened forms (eg ones in memory) Request one is obviously the lazy one for me. Request two will be sufficient as I can do the code to hide them after that.

Chauncey Philpot · Accepted Answer · 2013-09-03 05:45:19Z

8

For potential google searches

This was the answer I needed. This will hide any open userforms.

Dim UForm As Object

For Each UForm In VBA.UserForms 

    If UForm.Visible = True Then
        UForm.Hide
    End If

Next

answered Sep 3, 2013 at 5:45

Chauncey Philpot

3191 gold badge4 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

VBAbyMBA Over a year ago

I am using this to unload my user form and its working fine. I used If UForm.Visible = True Then UForm.unload End If

Collectives™ on Stack Overflow

Excel VBA Hide all opened userforms

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related