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.
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: 10/26/2013 07:18:00 - Revision: 4.0

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kbdtacode kbprb KB281542