Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading a Userform Jason Zischke Excel Programming 2 March 13th 06 08:37 AM
Loading website from userform Danny Boy via OfficeKB.com Excel Programming 0 January 29th 06 04:09 PM
Loading Userform Steven Cheng Excel Programming 3 December 9th 05 07:18 PM
Loading UserForm gives error Mats Samson Excel Programming 3 August 3rd 05 08:06 AM
Loading UserForm on start up. Kobus Excel Programming 2 April 1st 05 11:13 AM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"