Hi All,

I have inserted a Control Combo box into a cell in my spreadsheet but I am
having a hard time figuring out how to enter the drop down items. I would
like to add four items, example: Train, Car, Plane, Boat so that people can
select one of these items. I have already tried the following suggestion and
it seems that when I enter the range of cells, the range just disappears and
nothing is entered into the drop down list. Does anyone know why it's not
working? Any help will be very much appreciated, thanks...

This is what I tried...
Show the control Toolbox and click on the Design Mode icon (top left icon).
Then rightclick on your combobox from the control toolbox toolbar and select
Properties.
Click on ListFillRange and type in the address of a range that contains your
values (1 to 5).
You may want to type in an address for LinkedCell, too.