ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Validation- Require Entry in a Field (https://www.excelbanter.com/excel-discussion-misc-queries/231619-data-validation-require-entry-field.html)

KrispyData

Data Validation- Require Entry in a Field
 
I read some old posts that state you can create message that tells the user
an entry is required but it does not enforce it. But, is there a way to
require an entry in a field?

T. Valko

Data Validation- Require Entry in a Field
 
The short answer is no.

You can do things to try to coax the user to enter something like showing
messages but ultimately, the user has all the power. No matter what you try
the user can always defeat it if they're so inclined. All they have to do is
close the app or even shut off the computer. How can you stop that?

--
Biff
Microsoft Excel MVP


"KrispyData" wrote in message
...
I read some old posts that state you can create message that tells the
user
an entry is required but it does not enforce it. But, is there a way to
require an entry in a field?





All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com