| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo Box for a list of records
How can I create a combo box that can be used in a column of data (ie, having
a column of states and a combo box of all the states instead of typing in for each record) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combo Box for a list of records
I figured out how to use data validation for this. The next step would be to
filter the list based upon the value in another field (in the same record/row). IE, if I selected Illinois, the City colum would only list valid cities in IL? Any suggestions? "dascooper" wrote: How can I create a combo box that can be used in a column of data (ie, having a column of states and a combo box of all the states instead of typing in for each record) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combo Box for a list of records
One way is to create Filter. Select your data including the column
header. Then click on Data Filter. From DropDown boxes on the top row you can make a selection. AQIB RIZVI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List box or Combo box?? | Excel Discussion (Misc queries) | |||
| How do I set up a list of all of my music records | Excel Worksheet Functions | |||
| Combo box or list box | Excel Discussion (Misc queries) | |||
| Restructuring records into a list | Excel Worksheet Functions | |||
| Combo Box List | Excel Discussion (Misc queries) | |||
Linear Mode
