XL97: How to Temporarily Hide a UserForm (161536)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q161536 SUMMARY
In earlier versions of Microsoft Excel, if you use the Hide method to hide
a custom dialog box, Microsoft Excel does not hide the dialog box until the
macro that contains the Hide method is finished running.
In Microsoft Excel 97, if you use the Hide method to hide a UserForm, the
UserForm is hidden immediately. You can redisplay the UserForm later 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 (using the
Hide method and the Unload statement).
REFERENCES
For more information about Hiding UserForms, click the Office Assistant,
type hide, click Search, and then click to view "Hide Method".
For more information about Unloading UserForms, click the Office Assistant,
type unload, click Search, and then click to view "Unload Statement".
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Excel Help is not installed on your
computer, please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbProgramming KB161536 |
---|
|