Required Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 19 Feb 2008 23:53 GMT

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?

Reply to this Message

Stan Brown - 21 Feb 2008 06:36 GMT

Tue, 19 Feb 2008 15:53:00 -0800 from Bryan
<Bryan@discussions.microsoft.com>:

> 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".

Signature

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?

Reply to this Message

Dave Peterson - 21 Feb 2008 14:47 GMT

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

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

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

Signature

Dave Peterson

Reply to this Message

Stan Brown - 22 Feb 2008 10:04 GMT

Thu, 21 Feb 2008 08:47:29 -0600 from Dave Peterson
<petersod@verizonXSPAM.net>:

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

> 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... :-)

Signature

Reply to this Message

scott - 22 Feb 2008 15:41 GMT

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

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

Reply to this Message