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.


+-------------------------------------------------------------------+
|Filename: DropDown.jpeg |
|Download: http://www.excelforum.com/attachment.php?postid=4537 |
+-------------------------------------------------------------------+

--
dschlamp17
------------------------------------------------------------------------
dschlamp17's Profile: http://www.excelforum.com/member.php...o&userid=32913
View this thread: http://www.excelforum.com/showthread...hreadid=527341