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. RefEdit control does not work on form in a Com Add-In in Excel

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

View products that this article applies to.

This article was previously published under Q281542

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB281542, kbprb, kbdtacode

↑ Back to the top

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