multiple selection box

[rpod51]

Hi all,
I have five ranges (in columns) of numbers with the range names as headings, and am trying to find a way to make a combobox let me choose the range I want and then select the item in that range and use that value to populate a cell. Is this possible?
Thanks in advance,
rpod

 

[Norie]

Not with just one combobox.

Try a combobox with a list of the named ranges and another which is populated using the data from on the named range selected .

For putting the value on a worksheet you could just use a commandbutton.