Userform load problem...please help!

[Ozgur Pars]

Hi,
I have a userform with a multitab on it. While I waa adding controls onto it
it suddendly stoped loading and started to give me this error:
Path/File Access Error
Run-time error '361'
The message when pressed on OK is "Can't load or Unload this Object"

When I press debug it highlights the Userform1.show line in my code.

- I added the multi tab control recently do I have to specify which page to
load? (But it did work even after adding teh multi tab)
- Did I hit a limit of controls one can put on a userform? Is there such a
limit and would it even give me such a message?

I really have to get around this problem and any help would be greatly
appreciated.

Ozgur

 

[halim]

Hi Oz.,

Can you more specify what code are in your userform class?

may be I can solve if you send the codes to my email : (e-mail address removed)
the yellow highlights means the error that occured.


thanks,

halim


Ozgur Pars menuliskan:

 

[raypayette]

Multitab forms may be tricky, specially if you have more than 2 tabs!
Very often the error messages from Excel have very little to do with
the real problem. Repeat the programming step by step and determine
where it bugged.

HTH

 

[Ozgur Pars]

Halim, Ray,
thanks for your replies. I solved(???) the problem by changing the userform
name from userform1 to userform2... I have absolutely no idea why the problem
was occurring but its working now.

Anyway appreciate your time and help.

Ozgur