Linking combo box items to a data list

[James Ducrou]

I was wondering if anyone knew how to link named items in
a combo box to a list of numbers (i.e. each item in the
combo box relates to a list of say 15 numbers.) Each of
the names in the combo box would have different values for
these 15 numbers. Help me please!

 

[Mark Graesser]

James,
One of the properties of a combobox is labeled LinkedCell. If you define a cell here, then the selected value in the combobox will be returned to that cell.

What do you mean by "link" to a list of numbers. Do you want to return the full list to a range on your sheet? Do you want to give the user an option to select one item from the list?

Also, depending on your worksheet design, you might find it more useful to use Data>Validation instead of a combo box. This lets you create a selection list directly in a cell instead of in a floating object.

Good Luck,
Mark Graesser
(e-mail address removed)

----- James Ducrou wrote: -----

I was wondering if anyone knew how to link named items in
a combo box to a list of numbers (i.e. each item in the
combo box relates to a list of say 15 numbers.) Each of
the names in the combo box would have different values for
these 15 numbers. Help me please!