View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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?