Hi
I try making simple userform to show row source from two columns based on two option . so first when run the userform should be the combobox1 ="" and if I select optionbutton1 then should fill combobox basd on column A and if I select optionbutton2 then should fill combobox basd on column B . this is what I have .
Private Sub UserForm_Activate()
ComboBox1.RowSource = ""
If OptionButton1.Value = True And OptionButton2.Value = False Then
ComboBox1.List = Sheets("SHEET1").Range("A2", Sheets("SHEET1").Range("A65536").End(xlUp)).Value
ElseIf OptionButton2.Value = True And OptionButton1.Value = False Then
ComboBox1.List = Sheets("SHEET1").Range("B2", Sheets("SHEET1").Range("B65536").End(xlUp)).Value
End If
End Sub
but this doesn't work . any idea to fix it ?