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

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

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

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

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: