Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Boxes
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Boxes
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Boxes
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Boxes
Debra Dalgleish has some very nice instructions he
http://contextures.com/xlDataVal01.html 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
combo boxes | Excel Discussion (Misc queries) | |||
Combo Boxes | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel |