XL2000: How to Temporarily Hide a UserForm (213744)

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site: For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:

How to Create a 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 command button control to the UserForm.
5. Change the properties of the command button to the following:

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

6. Add another command button control to the UserForm.
7. Change the properties of the command button to the following:

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

8. Add a text box control to the UserForm.

Sample Macro for Hiding the UserForm

1. Double-click the cmdHide command 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 the cmdUnload Click event:

   Private Sub cmdUnload_Click()
      Unload UserForm1
   End Sub
   					

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

   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 text box control.
8. Click Hide Form.
9. When you are prompted about whether to redisplay the UserForm, click Yes.
   
   The UserForm reappears, and the text in the text box is retained.
10. Click Unload Form.
11. When you are prompted about whether to redisplay the UserForm, click Yes.
    
    The UserForm reappears, but the text in the text box is not retained.
12. Click Unload Form.
13. When you are prompted about whether to redisplay the UserForm, click No.
    
    The UserForm is not redisplayed, and the macro ends.