Don't want cells left blank when using Data validation

[trucker]

I am using Data Validation and I don't want the user to go past a cell without putting in an entry. When I leave the box (ignore blank) unchecked it doesn't do anything after I have protected the document.

Help

 

[Mark W.]

What's your validation criteria?

 

[Dexter]

Data Validation

The only way I could accomplish what you are attempting is by: 1) Using a drop down list; 2) unchecking "lignore blank"; 3) choose any value form the list; 4) and last, protect the sheet.

Dexter

 

[trucker]

The user can add anything they want--- the cell just can't be left blank so a drop down list won't work

 

[Mark W.]

Why not set "Text length not equal to 0" and uncheck "Ignore blanks"?

 

[trucker]

I tried that and it still lets the user to tab past that cell to the next cell that needs information anyother ideas

 

[Mark W.]

Data Validation only governs the Edit process. If you don't edit the cell Data Validation has no impact.

 

[trucker]

So is there a way that I can get the user to input something before moving to the next cell?

 

[Mark W.]

I suppose the event could be enforced by a VBA macro.

 

[trucker]

Is there no other way I really don't like macros