I can't use user form!
 

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.

I can't use user form!
 

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

"rrk" skrev i melding
m...
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.

I can't use user form!
 

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