XL97: Page Fault Setting RowSource for ListBox or ComboBox

• Microsoft Excel 97 for Windows

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.

   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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component