Make cell entry in a range mandatory

**h4a4r6r6** · 02-13-2019, 01:18 PM

I have a sheet that lists names, towns and whether a person has been checked.

What I would like to do is when I enter something into cells A2 to A1000 then cells B2 to B1000 and E2 to E1000 become mandatory to have to enter something into.

Could someone help me with this please.

Thank you.

**6StringJazzer** · 02-13-2019, 01:57 PM

I tested this code in the worksheet module:

Please Login or Register  to view this content.

**h4a4r6r6** · 02-14-2019, 05:42 AM

Thank you 6StringJazzer. That's the kind of solution I'm after however when I enter something into column E and go to select a cell in column A to enter the next name, Excel hangs (not responding). Any ideas why this might be please?

**JeteMc** · 02-20-2019, 10:18 AM

If you are entering the names consecutively then the following formula based proposal may help.
A helper column, which may be moved and/or hidden for aesthetic purposes, is populated using: =OR(A2="",AND(A2<>"",B2<>"",E2<>""))
A formula is placed in data validation (custom) which reads: =F3=TRUE
In the attached file data validation is applied to A3:A10 such that if a name is entered in A2 then B2 and E2 must be populated before a name can be entered in A3 etc.
Let us know if you have any questions.

**6StringJazzer** · 02-20-2019, 01:03 PM

Originally Posted by h4a4r6r6

Thank you 6StringJazzer. That's the kind of solution I'm after however when I enter something into column E and go to select a cell in column A to enter the next name, Excel hangs (not responding). Any ideas why this might be please?

You may find JeteMc's solution a better fit, as it does not require macros. However, here is a fix for the problem in mine. I neglected to turn off events so that when the code makes a selection, it calls itself infinitely.

Please Login or Register  to view this content.

Make cell entry in a range mandatory

LinkBack

Thread Tools

Rate This Thread

Display

Make cell entry in a range mandatory

Re: Make cell entry in a range mandatory

Re: Make cell entry in a range mandatory

Re: Make cell entry in a range mandatory

Re: Make cell entry in a range mandatory

Thread Information

Users Browsing this Thread

Similar Threads

Make several cells mandatory if a cell in a range is filled out

How can I make a cell mandatory?

[SOLVED] How can I make a cell mandatory and only accept a Y or N?

[SOLVED] How can I make a cell mandatory and only accept a Y or N?

[SOLVED] How can I make a cell mandatory and only accept a Y or N?

[SOLVED] How can I make a cell mandatory and only accept a Y or N?

Making Cell Entry Mandatory

Bookmarks

Bookmarks

Posting Permissions