Opening a user form on start up error '424'

[ben.martin]

HI All

Ive been following the guide to making a booking form on this site

Ive checked the VBA code numerous times and i cant see what im doing wrong.

Ive even copied the code directly from the 'download sample excel' file on the website, into my created doc. and it wont work?! Ive also copied my code into the downloaded doc. and that works!!

Ive put the following code in ThisWorkbook (Code):

Please Login or Register  to view this content.

but i get a runtime error '424' Object required

Can anyone help?

I'm very new to this so obviously doing something ridiculous!

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[tigeravatar]

ben.martin,

In the code you provided, its looking for a userform named frmCourseBooking. After you created the userform with Insert > UserForm, did you change the name of the userform from UserForm1 to frmCourseBooking? If you did not, then that is why you're getting the error. Otherwise, the problem is somewhere in the UserForm_Initialize event code. In the link you provided, the Initialize code references the following controls that are expected to be on the userform:

txtName - Textbox
txtPhone - Textbox
cboDepartment - Combobox
cboCourse - Combobox
optIntroduction - OptionButton
chkLunch - Checkbox
chkVegetarian - Checkbox

If you do not have those controls, named as shown, then you will also receive that error message.

Hope this helps,
~tigeravatar

[ben.martin]

sorry about that chaps. code changed. appreciate the help

[royUK]

Thank you

The error will be found in the UserForm code, probably Initialize event

[ben.martin]

Thankyou tigeravatar and royUK

In checking that i definitely had all the controls on the userform i realised i had called one of them cmb rather than cbo.

Sorry for wasting your time and for posting incorrectly first time round.

Thanks again

Ben