IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?

DATA VALIDATION

"LAKEISHA M." escreveu:

IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?

Marcelo wrote...
DATA VALIDATION

Try it. Start off with the particular cell blank, and see if Excel does
anything to compell you to enter anything in it. Then enter something
in it and clear the entry. The only thing Excel would prevent with the
custom validation formula =NOT(ISBLANK(X99)) for cell X99 is editing
the cell contents by pressing [F2], clearing the cell contents in the
formula bar or in the cell if entering directly in cells, then entering
the blank result. Most people would just press [Delete], and Excel's
data validation does nothing to prevent that.

"LAKEISHA M." escreveu:
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?

You'd need to use event handlers, which means you'd need to insist that
macros were enabled. Specifically, you'd use BeforeSave and BeforePrint
event handlers in the ThisWorkbook class module, and set their Cancel
parameters to TRUE if the cells requiring entry were blank. That way
users couldn't save or print without making mandatory entries.

I just like to use an adjacent cell and inform the user:

=if(a1<"","","<--- Please enter something!!!")

Format it nice big bold red letters.



LAKEISHA M. wrote:

IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?

--

Dave Peterson