run time 424 - auto open user form

[lsmithies]

please help

created user form and added

Private Sub Workbook_Open()
UserForm1.Show
End Sub

to autoload form when workbook is opened

all i get is a runtime error 424 object required.

much appreciated.

 

[Norie]

Do you have a userform called UserForm1?

Do you get a chance to Debug?

If you don't then goto Tools>Options... and select Break on All Errors on the General tab.

If there are any errors caused by showing the userform that should allow you to debug them.

 

[lsmithies]

hi norie

that worked a treat, had some nargles hiding in the code

many thanks