| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up/use drop down list in excel
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i set up/use drop down list in excel
Activate the Forms toolbar. Choose ComboBox from the object and draw it where you want. Right click it and, in the Control Area, define which cells contain the list of values that you want to appear in the combobox. Also define Cell Link, the cell where the chosen value will be placed. It's a piece of cake... -- oteixeira ------------------------------------------------------------------------ oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320 View this thread: http://www.excelforum.com/showthread...hreadid=564797 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i set up/use drop down list in excel
To do it in a cell drop down, select 'Data' -- 'Data Validation' and in the
"Allow" box choose 'List'. Your source list can be on any sheet in the workbook. The source list can also take a dynamic named range as input. -- HTH JonR "oteixeira" wrote: Activate the Forms toolbar. Choose ComboBox from the object and draw it where you want. Right click it and, in the Control Area, define which cells contain the list of values that you want to appear in the combobox. Also define Cell Link, the cell where the chosen value will be placed. It's a piece of cake... -- oteixeira ------------------------------------------------------------------------ oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320 View this thread: http://www.excelforum.com/showthread...hreadid=564797 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i set up/use drop down list in excel
I have tried using this and it works great except in my drop-down list I have
three cities. But when I select one of the cities it inserts a number instead of the city name. Could you please tell me what I'm doing wrong?? Thanks -- Carolan "oteixeira" wrote: Activate the Forms toolbar. Choose ComboBox from the object and draw it where you want. Right click it and, in the Control Area, define which cells contain the list of values that you want to appear in the combobox. Also define Cell Link, the cell where the chosen value will be placed. It's a piece of cake... -- oteixeira ------------------------------------------------------------------------ oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320 View this thread: http://www.excelforum.com/showthread...hreadid=564797 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i set up/use drop down list in excel
That's how combo boxes work. If you want to continue to use it like that
then you need to use a formula in another cell to convert the number to a name. Suppose the 3 cities are (in order) Pittsburgh, Sault Ste. Marie and Merced. The linked cell is A1. =INDEX({"Pittsburgh";"Sault Ste. Marie";"Merced"},A1) Or, you could use a Data Validation drop down list in which case there is no linked cell and therefore doesn't require a formula. The drop down list is contained in the cell itself as opposed to the combo box which is an object and "sits" on top an area. Also, the drop down list is not always visible like the combo box. It's only activated and becomes visible when the cell that contains the drop down is selected. Biff "Carolan" wrote in message ... I have tried using this and it works great except in my drop-down list I have three cities. But when I select one of the cities it inserts a number instead of the city name. Could you please tell me what I'm doing wrong?? Thanks -- Carolan "oteixeira" wrote: Activate the Forms toolbar. Choose ComboBox from the object and draw it where you want. Right click it and, in the Control Area, define which cells contain the list of values that you want to appear in the combobox. Also define Cell Link, the cell where the chosen value will be placed. It's a piece of cake... -- oteixeira ------------------------------------------------------------------------ oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320 View this thread: http://www.excelforum.com/showthread...hreadid=564797 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I tie prices to a drop down list of products in excel? | Excel Discussion (Misc queries) | |||
| How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
| How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) | |||
Hybrid Mode
