XL2000: Referencing an Invalid UserForm Control Causes Excel to Crash (231081)

SYMPTOMS

When you reference a UserForm control in a Microsoft Visual Basic for Applications macro, Microsoft Excel may stop responding, and 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 in VBE6.DLL at 015f:65009f45

CAUSE

This problem may occur when all of the following conditions are true:

You have a RefEdit control on a user form.

-and-
You reference an invalid control in an event procedure for the RefEdit control.

-and-
You run the code from the Visual Basic Editor by clicking Run or pressing F5.

This problem does not occur if you display the user form by running a subroutine from Excel that shows the user form.

WORKAROUND

To prevent this problem from occurring, do not include a reference to a nonexistent control in an event procedure for a control. Such a reference will result in an error with controls other than RefEdit as well.

To work around this problem, use one of the following methods:

Close the user form in the Visual Basic Editor before running the macro.

To close the user form, select the form in the Visual Basic Editor, and click the Close button ("X") in the upper-right corner of the document window, or press CTRL+F4.

-or-
Show the user form with a subroutine using the Show method, and run the subroutine from Excel rather than in the Visual Basic Editor, for example:
```
Sub Runner()
    UserForm1.Show
End Sub
						
```

MORE INFORMATION