Hi,

I have a tool that I have built using standard Excel functions with no
VBA. It is an in-depth tool that uses multiple vlookups to provide a
user friendly pricing tool. One sheet (Input Sheet) contains all the
input information via user selectable drop downs and the second uses
the information from the first to create a quote. I am trying to make
this more interactive and want to add the ability for certain fields
to appear and/or disappear on the input sheet based off of previous
selections. Here is an example of what I would want: User choose
option A in drop down 1. Because of this choice, drop down 2
appears. If user chose option 2 in A then drop down two would not
appear or potentially would appear with different information.

I am not sure how to do this with VBA. This is clearly a simple if/
then type problem, but I am a VBA novice and so am not sure where to
start. Any code snippets or links to places that have snippets would
be helpful.

TIA!

JL