Combo Box

[Dave]

Hi,

Can anyone tell me how to include a range of cells for a
drop down combo box. When I right click on the box and
choose Format Control, there doesn't appear to be an
option to include cell ranges. I could add the range
through it's properties, but, I thought there was a
quicker way, cheers.

Dave.

 

[Dave Peterson]

There are two different comboboxes that look pretty darn similar.

It sounds like you used the combobox from the Control toolbox toolbar--you said
you used Properties to set the listfillrange.

The other combobox (aka dropdown) comes from the Forms toolbar. You right click
on it, select Format Control, then the Control Tab, then Input range.

One of the differences is the way the results are returned to the linked cell.

For the combobox from the controltoolbox toolbar, you'll see the entry that was
chosen.

For the dropdown from the Forms Toolbar, you'll see a number--it's an index into
that input range.

I used an input range of A1:A10 and a linked cell of B1. Then I can use this
formula to get the value:

=IF(B1=0,"",INDEX(A1:A10,B1))