XL97: How to Temporarily Hide a UserForm

Creating the UserForm

1. Save and close any open workbooks, and then create a new workbook.
2. Start the Visual Basic Editor (press ALT+F11).
3. On the Insert menu, click UserForm.
   
   This step inserts UserForm1 into the project.
4. Add a CommandButton control to the UserForm.
5. Change the properties of the CommandButton to the following.

         Property   Value
         --------------------
         Caption    Hide Form
         Name       cmdHide
   						

6. Add another CommandButton control to the UserForm.
7. Change the properties of the CommandButton to the following.

         Property   Value
         ----------------------
         Caption    Unload Form
         Name       cmdUnload
   						

8. Add a TextBox control to the UserForm.

Sample Macro for Hiding the UserForm

1. Double-click the cmdHide CommandButton on UserForm1.
2. Type the following code for the cmdHide Click event:

          Private Sub cmdHide_Click()
              UserForm1.Hide
          End Sub
   						

3. Type the following code for cmdUnload Click event:

          Private Sub cmdUnload_Click()
              Unload UserForm1
          End Sub
   						

4. On the Insert menu, click Module.
5. Type the following code into this module:

          Sub Show_Form()
   
              UserForm1.Show   'Display the UserForm
   
              Do
                  response = MsgBox("Do you want to redisplay the form?", _
                      vbYesNo)
   
                  If response = vbYes Then
   
                      UserForm1.Show  'Redisplay the UserForm.
   
                  End If
   
              Loop Until response = vbNo  'Do not redisplay the UserForm.
   
          End Sub
   						

6. Run the Show_Form macro.
7. Type text in the TextBox control.
8. Click Hide Form.
9. When you are prompted whether to redisplay the UserForm, click Yes.
   
   The UserForm reappears, and the text in the TextBox is retained.
10. Click Unload Form.
11. When you are prompted whether to redisplay the UserForm, click Yes.
    
    The UserForm reappears, but the text in the TextBox is NOT retained.
12. Click Unload Form.
13. When you are prompted whether to redisplay the UserForm, click No.