Combing Ranges in Combo Box

[kyleboyd]

A fairly simple task, but I can't figure out how to do it.
I would like to have dynamic named ranges from multiple different sheets all combined into one combolist for users to pick from.

ie

combobox1.rowsource="Range1", "Range2", "Range3"

(I know that is not the correct syntax)

TIA!

 

[Norie]

The only way I can think of doing it would be like this.

For Each cl in Range("Range1")
 
        Combobobo1.Additem cl.Value
Next cl
 
For Each cl in Range("Range2")

       Combobobo1.Additem cl.Value
Next cl
 
For Each cl in Range("Range3")

        Combobobo1.Additem cl.Value
Next cl

 

[kyleboyd]

Perfect, works for me. Thanks Norie!