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

This article was previously published under Q281542
This article has been archived. It is offered "as is" and will no longer be updated.
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.
XL2000
Properties

Article ID: 281542 - Last Review: 10/26/2013 07:18:00 - Revision: 4.0

  • Microsoft Excel 2000 Standard Edition
  • kbnosurvey kbarchive kbdtacode kbprb KB281542
Feedback