Control Display of Drop Down List in Validation

I am currently working on a order form that requires an "X" to be placed in order to make a selection. The problem being is that some options have a drop down list composed of a named datarange or a straight text string. Which in turn completes the option price based on what is selected.

I want to be able to not show the drop down contents until the "X" is placed
in the proper field by adding a formula to the cells validation.

Thanks in advance.

You can create another named range, NA, with one cell that contains "N/A"
Then, in the data validation dialog box, choose Allow: List
In the Source box, type a formula that refers to the cell that should
contain the "X":
=IF(E8="X",MyList,NA)
Remove the check mark from "Ignore Blank"
Click OK

dschlamp17 wrote:
> I am currently working on a order form that requires an "X" to be placed
> in order to make a selection. The problem being is that some options
> have a drop down list composed of a named datarange or a straight text
> string. Which in turn completes the option price based on what is
> selected.
>
> I want to be able to not show the drop down contents until the "X" is
> placed
> in the proper field by adding a formula to the cells validation.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html