I have two named ranges - name1 and name2 and one ComboBox and two OptionButtons button1 and button2. I want ComboBox to display name1 values when button1 is pressed, and name2 values when button2 is pressed. The event code for button1, e.g., has the code:

ComboBox.RowSource = name1

But for some reason the ComboBox displays no values. I know the named ranges are valid because when I set ComboBox.RowSource =name1 in the form itself, it works perfectly.

Any help on how the RowSource property can be set to a named range at runtime would really be appreciated.

Thanks very much.