How do I create a mandatory field in Excel

R

RSP

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?
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top