2 Option Button Groups

[harveya915]

Got a UserForm with 2 groups of Option buttons (OptionButtons 1&2 = Group1, OptionButton 3&4 = Group2).

I need to have text entered into a textbox depending on which options from each group are selected.
I know the code for when only using one group:

Private Sub CommandButton1_Click()
If OptionButton1.Value = True Then
TextBox1.Value = "Test Text"
End If

Private Sub CommandButton1_Click()
If OptionButton2.Value = True Then
TextBox1.Value = "Test Text 2"
End If

End Sub

Now I just need to know how to incorporate when selecting per-say OptionButton1 and OptionButton3, or 1&4, or 2&3, or 2&4.

Much thanks!

 

[ranman256]

put the options into 2 FRAMEs (groups).
Then the frame gets the value of the options chosen in it.

 

[harveya915]

put the options into 2 FRAMEs (groups).
Then the frame gets the value of the options chosen in it.

I'm a noob, so i wouldn't know what FRAMES would be. Sorry. But thank you so much for the reply!

 

[harveya915]

I did manage to find out that all I have to do is add "And", for example:

Private Sub CommandButton1_Click()

If OptionButton1.Value = True And OptionButton3.Value = True Then
TextBox1.Value = "Test Text 1"
End If

If OptionButton1.Value = True And OptionButton4.Value = True Then
TextBox1.Value = "Test Text 2"
End If

If OptionButton2.Value = True And OptionButton3.Value = True Then
TextBox1.Value = "Test Text 3"
End If

If OptionButton2.Value = True And OptionButton4.Value = True Then
TextBox1.Value = "Test Text 4"
End If
 
End Sub