IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
|
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? |
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. |
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
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 |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com