option buttons in user forms

[VBAmalta89]

I have two frames in a user form. Above each of these frames is an option button.

What I need is for these option buttons to control which frame is activated, i,e when the user form is launched both frames are inactive but once the user clicks on one of the option buttons the frame becomes active.

Can i do this or something similar in VBA?

 

[John_w]

Set the Enabled property of each frame in the option button's Click event:

Private Sub OptionButton1_Click()
    Me.Frame1.Enabled = True
    Me.Frame2.Enabled = False
End Sub

and similar for the other option button.

 

[VBAmalta89]

ok that works..just one more question..

how can i make it that when the user form is launched both frames are disabled until the user selects an option button?

 

[John_w]

Set each frame's Enabled = False at design time or in the Userform_Initialize