Multi-Selection on UserForm

[Babynod]

Hi All

currently working on a UserForm where people can request new accounts for their team members.
i was thinking of using check boxes or option buttons for 3 of the options to say what systems the user needs access to(BLS/ANA production environment and BLS/ANA Test environment)
users don't always need access to both (or sometimes none hence the NO option)so they need to be separate.

i currently don't have any code for this part as i haven't been able to find anything that suits.

unless there's a better way to do this?

 

[portews]

Are you just looking for code to exclude the other two if you select No? What are the check box names? What happens to the data, anything special, or do you have that sorted out?

Private Sub ckbxProdNo_Change()
If ckbxProdNo.Value = True Then
    ckbxProdBLS.Value = False
    ckbxProdBLS.Enabled = False
    ckbxProdANA.Value = False
    ckbxProdANA.Enabled = False
Else
    ckbxProdBLS.Enabled = True
    ckbxProdANA.Enabled = True
End If
End Sub

Same for test

 

[Babynod]

Are you just looking for code to exclude the other two if you select No? What are the check box names? What happens to the data, anything special, or do you have that sorted out?

Private Sub ckbxProdNo_Change()
If ckbxProdNo.Value = True Then
    ckbxProdBLS.Value = False
    ckbxProdBLS.Enabled = False
    ckbxProdANA.Value = False
    ckbxProdANA.Enabled = False
Else
    ckbxProdBLS.Enabled = True
    ckbxProdANA.Enabled = True
End If
End Sub

Same for test

i want it to fill out a YES or NO in my table in the below columns.

just realised aswell as its a checkbox i could get rid of the NO box and default it to NO unless the box is checked then it would change it to YES