Combo Boxes

[Neil Holden]

Good afternoon Gurus, can somebody help me. I want to create a combo box
with a list;

1. test
2. test2
3. test3

And so on. If the user selects test for example i want the test to
automatically appear in the active cell. Is this possible?

Much appreciated.

Neil.

 

[Luke M]

Is there a particular reason you want a combo box instead of data validation?
(which would be simpler)

If you insist on the combo box, you will need to link the box to a cell
(under format control, let's assume linked to B2) this will generate a number
1 - 3. Then, have a list somewhere (lets say A2:A4) of your values.

Your formula to display choice of combo box then becomes:
=INDEX(A2:A4,B2)

 

[Neil Holden]

Data Validation? How would I do that? Thanks.

Is there a particular reason you want a combo box instead of data validation?
(which would be simpler)

If you insist on the combo box, you will need to link the box to a cell
(under format control, let's assume linked to B2) this will generate a number
1 - 3. Then, have a list somewhere (lets say A2:A4) of your values.

Your formula to display choice of combo box then becomes:
=INDEX(A2:A4,B2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Luke M]

Under Data - Validation, you can choose List and type in what you want
displayed. This will create an in-cell dropdown.

If your list in in a group of cells, you can also make a cell reference,
instead of typing the list out in the dialogue.

 

[Dave Peterson]

Debra Dalgleish has some very nice instructions here:
http://contextures.com/xlDataVal01.html