The information in this article applies to:
SYMPTOMSWhen you close a UserForm in Microsoft Excel 97, the program stops responding (hangs). CAUSEThis problem occurs when all of the following conditions are true:
-and- -and- WORKAROUNDTo work around this problem, do not close a UserForm that is collapsed by a RefEdit control. Instead, expand the UserForm by clicking the RefEdit control button, and then close the UserForm. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000. MORE INFORMATION
In Microsoft Excel 97, a RefEdit control allows you to select a range of
cells in a worksheet. When you select the range of cells, a UserForm
that contains a RefEdit control collapses to allow you to see more of
your worksheet.
Q158402 XL97: Using the RefEdit Control with a UserForm Additional query words: XL97 locks lockup freezes
Keywords : kbdta KbVBA |
Last Reviewed: November 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |