I can't use user form!

R

rrk

Hi all,

I don't know why I can't load any user form. I am using Load
(userform) and userform.Show commands, but it results in a microsoft
visual basic error message that says "Run-time error 361: can't load
or unload this object". I have never used forms in excel before. Is
there any special setting that should be enabled in order to be able
to use user forms? I am running excel 2002 and visual basic 6.3. I
appreciate any help.
 
H

Harald Staff

Hi

A userform has a name, by default Userform1 for the first, Userform2 for the
second, ... unless you change it yourself in the Properties window. Address
the form by its name:

Load Userform1

Userform1.Show

HTH. Best wishes Harald
 
R

rrk

A userform has a name, by default Userform1 for the first, Userform2 for the
second, ... unless you change it yourself in the Properties window. Address
the form by its name:

Load Userform1

Userform1.Show

Thanks a lot. I was using the correct name for the user form. However,
I used load (), which caused the error. It worked fine after removing
the parentheses.

rrk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top