software

I am currently working on a order form that requires an quot;Xquot; 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 quot;Xquot; is
placed
in the proper field by adding a formula to the cells validation.

Thanks in advance. -------------------------------------------------------------------
|Filename: DropDown.jpeg |
|Download: www.excelforum.com/attachment.php?postid=4537 |
-------------------------------------------------------------------

--
dschlamp17
------------------------------------------------------------------------
dschlamp17's Profile: www.excelforum.com/member.php...oamp;userid=32913
View this thread: www.excelforum.com/showthread...hreadid=527341You can create another named range, NA, with one cell that contains quot;N/Aquot;
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 quot;Xquot;:
=IF(E8=quot;Xquot;,MyList,NA)
Remove the check mark from quot;Ignore Blankquot;
Click OK

dschlamp17 wrote:
gt; I am currently working on a order form that requires an quot;Xquot; to be placed
gt; in order to make a selection. The problem being is that some options
gt; have a drop down list composed of a named datarange or a straight text
gt; string. Which in turn completes the option price based on what is
gt; selected.
gt;
gt; I want to be able to not show the drop down contents until the quot;Xquot; is
gt; placed
gt; in the proper field by adding a formula to the cells validation.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html