Microsoft KB Archive/213778

= XL2000: Unexpected Behavior for RefEdit Control in Binder =

Article ID: 213778

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:
 * 1) Activate the section that contains the worksheet.
 * 2) Click View Outside on the Section menu.

The worksheet appears in an Excel window.
 * 1) Switch to the Visual Basic Editor and press F5 to run the UserForm.
 * 2) 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.
 * 1) Click Close and Return to Binder on the File menu in Excel.



STATUS
Microsoft 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.

Additional query words: vbe XL2000

Keywords: kbbug kbpending kbprogramming kbui KB213778

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.