Required Cell

  • Thread starter Thread starter Bryan
  • Start date Start date
B

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?
 
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?
Click to expand...

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?
 
I would use a nearby cell (column E???) and a formula:

=if(a2="","",if(d2<>"","","Please choose something in column D"))
 
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"))
Click to expand...

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?
 
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
 
Back
Top