Runtime error 424 Object Required - HELP ME
hi, when i run macro ,i have this error keeps poping up "Runtime error 424 Object Required ".
When i click debug they pointing to ==> UserForm1.Show
pls .help me!
Note: Below code is taken from One of my MOUDLE
Please Login or Register to view this content.
Last edited by joh46k; 05-09-2013 at 02:30 AM.
THis is a VBA question, I will move it to that forum for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins: Thank you ! PLEASE HELP ME .. that error giving me a headache.
Check whether you are having the UserForm1
If suppose you named the userform with different name then just mention the userform name something like this...
Just select the userform and press F4 to get the properties window and see the name provided for the userform.Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
BUT still have that errror
Please read the whole content which I posted in Post #4Originally Posted by joh46k
Do you have any code in the userform's Initialize or Activate events?
If you do it'll be in the userform module.
If posting code please use code tags, see here.
YES , i have UserForm1. I never named it with any other name just "UserForm1"Check whether you are having the UserForm1
If suppose you named the userform with different name then just mention the userform name something like this...
Just select the userform and press F4 to get the properties window and see the name provided for the userform.Please Login or Register to view this content.
@Norie: I have two userform's Initialize .
one is in the module (modules) and another one is in the UserForm1 (Forms)
Last edited by joh46k; 05-09-2013 at 02:32 AM.
Then it should work
Sorry I don't have any other suggestions
Only one is an event, the one in the userform module.
The one in the standard module is a sub with the name UserForm_Initialize.
It's the code in the userform Initialize that could be causing the problem.
Can you post that code?
Re: Runtime error 424 Object Required - HELP ME
@Norie : Userform intialize is all the way bottom. pls check it! .
Please Login or Register to view this content.
in your vbeditor click tools-options and then select the general tab and change the error trapping setting to "break in class module" and then run the code again and see which line really causes the problem
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks !.... now YELLOW Line pointing to this "Me.Label2.Caption = Sheet2.Range("A1").Value ''Last Update Code "
Please Login or Register to view this content.
Note: To see full code .pls refer to post #12
Last edited by joh46k; 05-09-2013 at 03:06 AM.
That means you either don't have a control named Label2 on the form or there is no worksheet with the codename Shret2, or both.
@Norie @JosephP : yea, NOW after they point to the correct error . i know where i made the mistake
I accidentally, delete the sheet2
Last edited by joh46k; 05-09-2013 at 03:27 AM.
Now its working .Thank u guys for quick reply !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks