Basketball Userform adjustment

[lacogada]

Made a userform for basketball pool.

When I click options from different sections .... the previous section
does not stay picked.

I would like each section's button to stay selected when I click on another section.

Hers's some of the code

Private Sub OptionButton1_Click()
If OptionButton1 Then myStr = "Kansas"
Range("C2") = myStr
End Sub

Private Sub OptionButton2_Click()
If OptionButton2 Then myStr = "Notre Dame"
Range("C2") = myStr
End Sub

Private Sub OptionButton3_Click()
If OptionButton3 Then myStr = "Purdue"
Range("C2") = myStr
End Sub

Private Sub OptionButton4_Click()
If OptionButton4 Then myStr = "Pitt"
Range("E2") = myStr
End Sub

Private Sub OptionButton5_Click()
If OptionButton5 Then myStr = "Florida"
Range("E2") = myStr
End Sub

 

[Gary McMaster]

You need to put the different groups in a "Frame" (on the tool bar). Then they will be handled as independent groups. Only one selection per frame.

Gary

 

[lacogada]

Thanks for reply

Tried adding frame and it covers team sections.
Tried "sending to back" and that did not work.

Did I need to make the frame 1st ... then put the teams in seperate frames ?

If so, is there now a way to do it without having to redo all I've done ?

 

[Gary McMaster]

Add the frame and then drag the option buttons into the frame.

Gary

 

[lacogada]

Great .... that'll work.

The only thing now is the "frame outline" shows on the userform.

Is there a way to turn that off ?

 

[Gary McMaster]

I don't know. Have a look in the properties for the frame. If you can't turn it off maybe you can make it the same color as the form or some other trick.

I know if you make it invisible it takes all the buttons with it.

Gary

 

[lacogada]

There is a "BorderStyle" in properties that allows to turn off.

Thanks for the help !