ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loading userform problem (https://www.excelbanter.com/excel-programming/375913-loading-userform-problem.html)

Mats Nilsson

Loading userform problem
 
Hi All,
In a model with some userforms I´ve made the loading like this

"Load ufAvskr
ufAvskr.Show"

It works mostly OK but for one of the userforms there is a problem, runtime
error 424, Object is needed.

Thanks in advance for any help how I can solve this.

Regards
Mats

--
ESI Update

Bob Phillips

Loading userform problem
 
That sounds as though it may be a problem in the userform itself.

Goto ToolsOptions in the VBIDE, and in the General tab set the Error
trapping to Break on All Errors, then try it again and see if it tells you
where.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mats Nilsson" wrote in message
...
Hi All,
In a model with some userforms I´ve made the loading like this

"Load ufAvskr
ufAvskr.Show"

It works mostly OK but for one of the userforms there is a problem,

runtime
error 424, Object is needed.

Thanks in advance for any help how I can solve this.

Regards
Mats

--
ESI Update




Mats Nilsson

Loading userform problem
 
Hi Bob,
Thanks for your answer. When I checked the userforms control once again i
saw that one of them had wrong name in the code.
Best Regards
Mats
--
ESI Update


"Bob Phillips" wrote:

That sounds as though it may be a problem in the userform itself.

Goto ToolsOptions in the VBIDE, and in the General tab set the Error
trapping to Break on All Errors, then try it again and see if it tells you
where.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mats Nilsson" wrote in message
...
Hi All,
In a model with some userforms I´ve made the loading like this

"Load ufAvskr
ufAvskr.Show"

It works mostly OK but for one of the userforms there is a problem,

runtime
error 424, Object is needed.

Thanks in advance for any help how I can solve this.

Regards
Mats

--
ESI Update






All times are GMT +1. The time now is 02:57 AM.

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