Thread: User Form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default 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