Microsoft KB Archive/281542

= RefEdit control does not work on form in a Com Add-In in Excel =

Article ID: 281542

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q281542



SYMPTOMS
When you insert a RefEdit control on a form that is located in a Com Add-In, the control does not work as expected. While the form is displayed, you are unable to select a range in the current worksheet. And, the RefEdit control button for collapsing or expanding the form does not work.



CAUSE
The RefEdit Control is designed to work only when placed on a form in an Excel VBA project. The project has to be stored in an *.xls or *.xla file. For this control to function correctly, some special interaction between Excel, UserForms, and the control itself is required.

Additional query words: XL2000

Keywords: kbdtacode kbprb KB281542

-

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

© Microsoft Corporation. All rights reserved.