ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform load problem...please help! (https://www.excelbanter.com/excel-programming/366655-userform-load-problem-please-help.html)

Ozgur Pars[_2_]

Userform load problem...please help!
 
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

Userform load problem...please help!
 
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 :
the yellow highlights means the error that occured.


thanks,

halim


Ozgur Pars menuliskan:
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



raypayette[_7_]

Userform load problem...please help!
 

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


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=559585


Ozgur Pars[_2_]

Userform load problem...please help!
 
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

"raypayette" wrote:


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


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=559585




All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com