using radio buttons to select a named range for combobox list

Posted by John on November 05, 2001 12:36 PM

I'm trying to create a Userform in VBA that has radio buttons to select a named range to use for the listsource for a combobox in the same user form. I'm not quite sure how to do this. Any pointers?

Thanks for the help.

John

Posted by Bob Umlas on November 05, 2001 12:42 PM

The click event for the radio button should use something like
Private Sub OptionButton1_Click()
Me.ComboBox1.RowSource = "C1:C4"
End Sub