Hi Roger

Copy the below code behind the userform. CommandButton1 is within the Frame
and CommandButton2 is outside the frame

Private Sub CommandButton1_Click()
Me.Frame1.Visible = False
End Sub

Private Sub CommandButton2_Click()
Me.Frame1.Visible = True
End Sub

Private Sub UserForm_Initialize()
Me.Frame1.Visible = False
End Sub

--
Jacob


"Roger on Excel" wrote:

[Excel 2003]
I have a userform with a frame on it

The form displays some text boxes. I would like the default setting of the
frame to be not visible to the user, so I can set the property as such.

What I would like is to have a command button on the form which makes the
frame visible :

frame.visible=True??

and a command button within the frame to hide the frame

frame.visible=False??

Can anyone help?

Thankyou,

Roger