Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Unexpected Behavior for RefEdit Control in Binder

XL2000: Unexpected Behavior for RefEdit Control in Binder

View products that this article applies to.

This article was previously published under Q213778

↑ Back to the top

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.

↑ Back to the top

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.
  3. Switch to the Visual Basic Editor and press F5 to run the UserForm.
  4. 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.
  5. Click Close and Return to Binder on the File menu in Excel.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB213778, kbui, kbprogramming, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 213778
Revision : 6
Created on : 10/11/2006
Published on : 10/11/2006
Exists online : False
Views : 228