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) |