XL98: How to Temporarily Hide a UserForm

MORE INFORMATION

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 button 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 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 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 to redisplay the UserForm, click No.
    
    The UserForm is not redisplayed, and the macro ends.