Program a drop down list to show a specific response depending on the selction

V

Vita Cator

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??
 
E

Ed

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
lookup drop down 1
Help with drop down selection and populating related data... 9
Formula re value in column C or D, calculations made on either in column E? 8
Colour-coding a cell from a drop down list 1

Top