Minimize/Maximize Button to a UserForm

< Back to Search results

 Category: [Excel]  Demo Available 

Minimize/Maximize Button to a UserForm


Excel VBA: Add a Minimize/Maximize Button to a UserForm


Got any Excel/VBA Questions? Free Excel Help


Add a Minimize/Maximize Button to a UserForm

Here is a nice simple method you can use for a Minimize/Maximize Button on a UserForm. Just add a ToggleButton to the top of the UserForm. Adjust 0.25 to suit your needs.

Dim dHeight As Double

Private Sub ToggleButton1_Click()

	If ToggleButton1.Value = True Then

		Me.Height = Me.Height * 0.25


       	Me.Height = dHeight

    End If

End Sub

Private Sub UserForm_Initialize()

    dHeight = Me.Height

End Sub

See also:

Loop All Worksheets/Sheets in Workbook & Apply Code
Excel VBA Loops Explained
Loop Through a Folder of Excel Workbooks
Mask Date Entry in Excel
Mask Time Entry in Excel


See also Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions.


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)