Combo Boxes
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.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Neil Holden" wrote:
Data Validation? How would I do that? Thanks.
"Luke M" wrote:
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!*
"Neil Holden" wrote:
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.
|