XL97: Page Fault Setting RowSource for ListBox or ComboBox (171092)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q171092 SYMPTOMS
If you run a MouseDown, MouseMove, or MouseUp macro that is attached to
either a ListBox or a ComboBox control on a UserForm, you may receive the
following error message:
This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
If you click Details, you receive an error message similar to the
following:
EXCEL caused an invalid page fault in module FM20.DLL at
0137:60025b1b.
CAUSE
This problem occurs if all of the following conditions are true:
- You create a ListBox or a ComboBox control on a UserForm.
-and-
- You attach a MouseDown, a MouseUp, or a MouseMove event macro to
the control.
-and-
- The MouseDown, MouseUp or MouseMove macro attempts to set the RowSource
property for the control.
-and-
- The RowSource property for the control was already set to a range of
cells.
-and-
- You perform an action that runs the MouseDown, MouseMove, or MouseUp
macro that is attached to the control.
RESOLUTION
To resolve this problem, do not set the RowSource property of the ListBox
or the ComboBox control in a macro that is attached to a MouseDown,
MouseUp, or MouseMove event if the RowSource property for the control is
already set.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about the RowSource property, click the Office
Assistant in the Visual Basic Editor, type RowSource, click Search, and
then click to view "RowSource Property."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kberrmsg kbprb kbProgramming KB171092 |
|---|
|