Hi Hoyos
Got to go out now.
Will reply in more detail later
donwb

"hoyos" wrote in message
...
Thanks for answering my question.
I think I know what the problem is. on the left where you find the project
explorer, There is missing the following:
"XYChartLabller"
How do I insert it?

"donwb" wrote:

Hi Hoyos

I created 2 Userforms 1 with 2 command buttons,
and the other blank.
On UF1,
Command button 2 is the exit or close
Command Button 1 is used to call up a second Userform2

This is the code in UF1:-
Private Sub CommandButton1_Click()
UserForm2.Show
End Sub

Private Sub CommandButton2_Click()
Unload UserForm1
End Sub

A code module opens UF1:-

Sub OpenUF1)
UserForm1.Show
End Sub

This worked OK for me.
donwb


"hoyos" wrote in message
...
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?


.