| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program a drop down list to show a specific response depending on the selction
I would like to create a price list that will show me
results for a specific selection. For example, I would like to chose a price and have it automatically bring up the description and any other fields that are only applicable to that selected item. Any idea the best way I should approach this?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program a drop down list to show a specific response depending on the selction
One way would be to set a macro and assign it to a custom button that would
activate the AutoFilter, using your ActiveCell value as the criteria. (Then a second button, probably, that would reset your list to "before filter".) HTH Ed "Vita Cator" wrote in message ... I would like to create a price list that will show me results for a specific selection. For example, I would like to chose a price and have it automatically bring up the description and any other fields that are only applicable to that selected item. Any idea the best way I should approach this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrict choices in one drop down list by response to another | Excel Discussion (Misc queries) | |||
| Based on the selction from a drop down box, jump to a cell | Excel Discussion (Misc queries) | |||
| how do i enable a drop down list depending on result of "if" funct | Excel Worksheet Functions | |||
| display text depending on coice from drop down list | Excel Discussion (Misc queries) | |||
| return a data list depending on a value selected within a drop dow | Excel Discussion (Misc queries) | |||
Linear Mode
