Solve : VBA code for Option Button choices on Userform?

1.	Solve : VBA code for Option Button choices on Userform?
Answer» Hi, I'm still struggling with this code I'm trying to get right. I need to REPLACE the ComboBox in the code below with option buttons INSTEAD. I have 7 option buttons I'd RATHER use then the ComboBox on my userform. Once the user selects one of the 7 choices from the option buttons, that choice name or I'm guessing OptionButton(?).Value would be placed in the code below instead of ComboxBox1.Value. And if POSSIBLE, can the Userform reset after it closes? if so, How? Thanks for all your help Code: [Select]PRIVATE Sub CommandButton1_Click() Selection.Offset(, 1).Resize(1, 3).Value2 = _ Array(ComboBox1.Value, TextBox1.Value, TextBox2.Value) Unload Me End Sub

Discussion