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

Article translations Article translations
Article ID: 281542 - View products that this article applies to.
This article was previously published under Q281542
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


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.


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.


Article ID: 281542 - Last Review: October 26, 2013 - Revision: 4.0
Applies to
  • Microsoft Excel 2000 Standard Edition
kbnosurvey kbarchive kbdtacode kbprb KB281542

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from