Some events do not run when you use the RefEdit control in an Excel macro (870756)

The information in this article applies to:

Microsoft Office Excel 2003
Microsoft Excel 2002
Microsoft Excel 2000
Microsoft Excel 97 for Windows

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 "Applies to" 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

Modification Type:	Minor	Last Reviewed:	9/12/2006
Keywords:	kbBug kbtshoot kbmacro KbVBA KB870756 kbAudEndUser kbAudITPRO