User Form
Brian,
In the VBE goto ToolsOptionsGeneral and choose "Break in Class Module."
The debugger will now show the line in the userform that's causing the
error.
hth,
Doug
"Brian C" wrote in message
...
Hi,
I'm trying to call a userform from a macro, using:
UserForm1.show
When I run the macro, I get a Run Time Error 91 Object Variable or With
Block Variable not set error. Because the code returns to the
UserForm1.show
statement in the macro rather than going on to the next step.
If I step through it, it proceeds back to the UserForm, and again stops at
the UserForm1.show statement.
I tried Load UserForm1 and had the same problem. How can I get it to
proceed to the next step in the original macro?
Thank you,
Brian
|