How do I create a mandatory field in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a log using excel. I want the data entry staff to use their initials
on the log when entering data. I want that initial field to be mandatory.
How can I set it up to be mandatory?
 
Why not get them to give you initials on start up, in an InputBox maybe.
Then you can add it yourself each time and save the user the trouble of
entering the same thing each line.

Or the current logged-on user, you could generate something yourself, either
with :
Environ("UserName")
GetUserName API call

NickHK
 
Back
Top