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 "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
Additional query words: XL2003 XL2002 XL2000 XL97
Keywords: kbtshoot kbbug kbmacro kbvba KB870756