Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default UserForm tanked

I have a UserForm called ChangesDialog that I have loaded literally 100's of
times. All of the sudden I am getting a "Run-time Error '424': Object
required" error message and the first line "Load ChangesDialog" is flagged.

Private Sub Main_Button6_Click()
Load ChangesDialog
ChangesDialog.Show
End Sub

ChangesDialog is a valid object and all spelling is correct. Again, I've
loaded this UserForm 100's of times before. Any ideas why this would suddenly
happen?

--
Jim T
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default UserForm tanked

Forget it. I found the problem.
--
Jim T


"Jim Tibbetts" wrote:

I have a UserForm called ChangesDialog that I have loaded literally 100's of
times. All of the sudden I am getting a "Run-time Error '424': Object
required" error message and the first line "Load ChangesDialog" is flagged.

Private Sub Main_Button6_Click()
Load ChangesDialog
ChangesDialog.Show
End Sub

ChangesDialog is a valid object and all spelling is correct. Again, I've
loaded this UserForm 100's of times before. Any ideas why this would suddenly
happen?

--
Jim T

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
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) Corey Excel Programming 2 January 9th 07 01:01 PM
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM


All times are GMT +1. The time now is 08:03 AM.

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

About Us

"It's about Microsoft Excel"