How do I create a mandatory field in Excel
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
"RSP" wrote in message
...
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?
|