Making a frame visible or not using a command button

R

Roger on Excel

[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
 
J

Jacob Skaria

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
 
P

Patrick Molloy

use one command button - this will toggle the frame visibility between on
and off
Private Sub CommandButton1_Click()
Frame1.Visible = NOT Frame1.Visible
End Sub
 
R

Roger on Excel

Thankyou Jacob And Patrick - both approaches are equally viable - Have a
great week,

Roger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top