Forum Discussion

jyothi_priya's avatar
jyothi_priya
Contributor
13 years ago
Solved

How to minimize a userform?

Hi, Is there any control or a property of the userform where I can minimize it whenever I want just like we do with normal windows??? Thanks Priya
  • YMinaev's avatar
    YMinaev
    13 years ago
    Hi,



    Add a loop to the Main routine to constantly check the form's Visible property and exit the loop when it equals false:

    Sub Main()

    UserForms.TestForm.Show



    While UserForms.TestForm.Visible

    ' do nothing

    Wend

    End Sub
jyothi_priya's avatar
jyothi_priya
Contributor
13 years ago
Hi Jared,



I want the main userform to have minimize button in the header. Using show method, it is displaying the userform for a second and then closing it.

I have written the code as follows:



Sub Main()

    UserForm.TestForm.Show

End Sub



Sub TestForm_cxButton1_OnClick()

    Action1

        -    

        -

    UserForm.TestForm.Visibile = False

End Sub



Now, how can I make TestForm visible till cxButton1 is clicked?