XL97: Unexpected Behavior for RefEdit Control in Binder
Article ID: 157986
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q157986
SYMPTOMS
When you use a RefEdit control on a UserForm in a Microsoft Binder
document, you are unable to select an area on the worksheet so that the
address of the selection fills the RefEdit control.
WORKAROUND
To work around this problem, view the Microsoft Excel Worksheet section
outside of the Binder before you display the UserForm that contains the
RefEdit control.
To view a Microsoft Excel worksheet outside of the Binder:
- Activate the section that contains the worksheet.
- Click "View Outside" on the Section menu. The worksheet appears in
a Microsoft Excel window.
- After you view the worksheet outside of the Binder, click "Close and
Return to Binder" on the File menu in Microsoft Excel.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
The RefEdit control is new to Microsoft Excel 97. This control allows you
to fill an input box with the address of a range by clicking a worksheet
and selecting the range.
Additional query words: XL97 8.0 8.00 vbe
Keywords: kbprogramming kbui KB157986