User Form

[krc547]

I need a user form that allows a user to select a check box and according to
which one they select only select item are visible on the form.

 

[sebastienm]

Hi,

- On the userform, add a checkbox, say CheckBox1.
- Now put all the controls that should show/hide based on checkbox1 on a
Frame, say Frame1
- in the userform code module, insert the code:

Private Sub CheckBox1_Click()
Frame1.Visible = CheckBox1.Value
End Sub

Checking or unchecking checkbox1 makes the Frame1 (and all controls on that
frame) show or hide.

To add another checkbox, follow the same process replacing CheckBox1 by
Checkbox2, Frame1 by Frame2 and same in the code:
Private Sub CheckBox2_Click()
Frame2.Visible = CheckBox2.Value
End Sub

....