Required Cell

[Bryan]

In any given row, if the cell in column A of that row has a value entered, I
want it required that a user choose something from a dropdown menu in column
D. How can I do this in Excel?

 

[Stan Brown]

Tue, 19 Feb 2008 15:53:00 -0800 from Bryan

In any given row, if the cell in column A of that row has a value
entered, I want it required that a user choose something from a
dropdown menu in column D. How can I do this in Excel?

You'll have to write a VBA macro, I think for the Worksheet_Change or
Worksheet_Open event depending on what you mean by "has a value
entered".

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

 

[Dave Peterson]

I would use a nearby cell (column E???) and a formula:

=if(a2="","",if(d2<>"","","Please choose something in column D"))

 

[Stan Brown]

Thu, 21 Feb 2008 08:47:29 -0600 from Dave Peterson

I would use a nearby cell (column E???) and a formula:

=if(a2="","",if(d2<>"","","Please choose something in column D"))

Oh sure, if you want to do things the easy way...

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

 

[scott]

If you used data validation, Data>Validation
Make the settings Validation criteria from List and set the list range
to column D.
You can also provide an error alert if you desire.

Scott