Run-time error 424 when trying to show userform

Ive created a userform that I want to have input data into specific cells in my worksheet. I have the userform created, and some of the other VB stuff written, but it is far from being functional. I have come across the first of what to is to be many problems (Im pretty rusty at VB).

I have a button on my spreadsheet that is supposed to show the userform using this macro

Please Login or Register  to view this content.

When I click the button, it breaks at "Form1.Show" giving me "Run-time error 424 : Object Required"

Ive been searching and reading reference material/tutorials on userforms but I cant find anything that helps.

Input is appreciated.

If you check your object browser, how is the form called? Probably "UserForm1"? That's the name of the form Excel is looking for in your code. The object 'Form1' is not known, thus 424 error.

Ive renamed the userform Form1 in the "name" section of the properties box.

Here is the file im working with. Ive deleted some of the stuff that I think probably shouldnt be out on the net. There will be some other macros and stuff that are used in the other version that I havent deleted files in. Im sure my code is probably an organizational mess...please excuse.

Ok, I checked your form. Its there as Form1 indeed. But when the Form1 intiates, its looking for object 'groovediatext', which does not seem to exist.
you can check it by yourself by debugging (F8) the 'Private Sub UserForm_Initialize()'

Originally Posted by Sbarro79

I think that your form name is other than Form1

edit: thelongpants was quicker

yeah!

(sorry for being off-topic)

thelongpants - yes, i see it now. I had misnamed that text box (grovediatext instead of groovediatext). I also didnt remember about pushing F8, but Ill be sure to do that a lot now.

Thanks for your help - its working now

Good to know! Please close thread as 'solved' and I appreciate some reputation stars :-)