Microsoft KB Archive/870756

= Some events do not run when you use the RefEdit control in an Excel macro =

Article ID: 870756

Article Last Modified on 9/12/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



SYMPTOMS
Consider the following scenario. You use Microsoft Visual Basic for Applications (VBA) to create a UserForm in Microsoft Excel. Additionally, you insert the RefEdit ActiveX control in the UserForm. When you use the RefEdit control in an Excel macro, some events that are associated with the RefEdit control do not run. For example, although the following events appear in the Events list, these events do not run:
 * BeforeUpdate
 * AfterUpdate



WORKAROUND
You may be able to use another event, such as the Change event, to accomplish your intended functionality. Test several events to see which one works best for your intentions



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
A hotfix for Microsoft Office Excel 2003 is available to resolve other problems that you may experience when you use events that are associated with the RefEdit control. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

886669 Description of the Excel 2003 post-Service Pack 1 hotfix package: September 24, 2004

Additional query words: XL2003 XL2002 XL2000 XL97



Keywords: kbtshoot kbbug kbmacro kbvba KB870756

-

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

© Microsoft Corporation. All rights reserved.