XL2000: Unexpected Behavior for RefEdit Control in Binder (213778)
The information in this article applies to:
This article was previously published under Q213778 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 issue, follow these steps:
- Activate the section that contains the worksheet.
- Click View Outside on the Section menu.
The worksheet appears in an Excel window. - Switch to the Visual Basic Editor and press F5 to run the UserForm.
- Select cells on the worksheet while the UserForm is displayed.
Notice that the address of the selection now fills the RefEdit
control when Excel is viewed outside of the binder document.
- Click Close and Return to Binder on the File menu in Excel.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
The RefEdit control was introduced in 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.
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kbpending kbProgramming kbui KB213778 |
|---|
|