Microsoft KB Archive/184986

= XL98: How to Temporarily Hide a UserForm =

Article ID: 184986

Article Last Modified on 9/12/2006

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184986



SUMMARY
If you use the Hide method to hide a custom dialog box in earlier versions of Microsoft Excel, Microsoft Excel does not hide the dialog box until the macro that contains the Hide method is finished running.

In Microsoft Excel 98, if you use the Hide method to hide a UserForm, the UserForm is hidden immediately. You can redisplay the UserForm by using the Show method in the macro (or in another macro). You can also use the Unload statement to hide a UserForm; however, any settings in the UserForm are lost. Note that you may want to use the Unload statement if you want to reset the UserForm.

This article explains how to create a UserForm and contains a sample Visual Basic for Applications macro that temporarily hides the UserForm (by using the Hide method and the Unload statement).



MORE INFORMATION
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers 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 requirements.

Creating the UserForm
To create the UserForm, follow these steps:

 Save and close any open workbooks, and then create a new workbook. Start the Visual Basic Editor (press ALT+F11). On the Insert menu, click UserForm.

This step inserts UserForm1 into the project. Add a CommandButton control to the UserForm.  Change the properties of the CommandButton to the following.      Property   Value

Caption   Hide Form Name      cmdHide  Add another CommandButton control to the UserForm.</li>  Change the properties of the CommandButton to the following. <pre class="fixed_text">     Property   Value --

Caption   Unload Form Name      cmdUnload </li> Add a TextBox control to the UserForm.</li></ol>

Sample Macro for Hiding the UserForm
To use the macro, follow these steps: <ol> Double-click the cmdHide button on UserForm1.</li>  Type the following code for the cmdHide Click event: Private Sub cmdHide_Click UserForm1.Hide End Sub </li>  Type the following code for cmdUnload Click event: Private Sub cmdUnload_Click Unload UserForm1 End Sub </li> On the Insert menu, click Module.</li>  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 </li> Run the Show_Form macro.</li> Type text in the TextBox control.</li> Click Hide Form.</li> When you are prompted to redisplay the UserForm, click Yes.

The UserForm reappears, and the text in the TextBox is retained.</li> Click Unload Form.</li> When you are prompted to redisplay the UserForm, click Yes.

The UserForm reappears, but the text in the TextBox is NOT retained.</li> Click Unload Form.</li> When you are prompted to redisplay the UserForm, click No.

The UserForm is not redisplayed, and the macro ends.</li></ol>

For additional information about hiding dialog boxes in earlier versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base:

141506 XL: How to Temporarily Hide a Dialog Box

<div class="references_section">