My guess is you do not have a Userform9. Open the VBE (Alt + F11). On the
left hand side of the screen should be the project explorer listing all of
the currently open workbooks including the one you are working on. In the one
you are wokring on do you see an object called UserForm9. As a guess it has
been deleted or renamed.
--
HTH...

Jim Thomlinson


"hoyos" wrote:

With the following code set in a userform:

Private Sub CommandButton1_Click()
UserForm9.Show
End Sub

When ever I press commandbutton1 I get the following error message:

Run-Time '1004'
Application-defined or object-defined error

Any fix for this?