Setting ComboBox.RowSource via Named Range

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.

Hi

Try

Please Login or Register  to view this content.

The way you were doing it, it assumed name1 was a variable, which would have contained nothing.


HTH

rylo

Rylo,
Thanks a million - that solved it!