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.

Did you type it like

A2:A10

and did you close the design mode after you were done?


--
Regards,

Peo Sjoblom



"LoriDe" wrote in message
...
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.

Yes that worked, thank you very much. I was originally entering the range
with parenthesis. BUT one more problem now. Say I have listed in the
following order...
Boat
Car
Plane
Train
If I select Car, Plane or Train - Boat disappears from the list. So I
expanded my list to include a range of six cells instead of four, one before
boat and one after train. Now Boat does not disappear but when I select an
item it will duplicate in the list. For some reason it automatically enters
the word in the first cell of the range and then it will be duplicated in the
list. Can you tell me how I can make it stop doing that?

"Peo Sjoblom" wrote:

Did you type it like

A2:A10

and did you close the design mode after you were done?


--
Regards,

Peo Sjoblom



"LoriDe" wrote in message
...
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.

Ok, I just figured it out. I had entered the range in both LinkedCell and
ListFillRange. I took the range out of LinkedCell and it is now working
properly. Thanks again for all your help

"LoriDe" wrote:

Yes that worked, thank you very much. I was originally entering the range
with parenthesis. BUT one more problem now. Say I have listed in the
following order...
Boat
Car
Plane
Train
If I select Car, Plane or Train - Boat disappears from the list. So I
expanded my list to include a range of six cells instead of four, one before
boat and one after train. Now Boat does not disappear but when I select an
item it will duplicate in the list. For some reason it automatically enters
the word in the first cell of the range and then it will be duplicated in the
list. Can you tell me how I can make it stop doing that?

"Peo Sjoblom" wrote:

Did you type it like

A2:A10

and did you close the design mode after you were done?


--
Regards,

Peo Sjoblom



"LoriDe" wrote in message
...
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.