Custom data validation??
Hi All,
I have an issue that i cannot solve using my small brain!!
I have attached a sheet, which probably makes more sense.
What i need to do is make sure users enter their domain\username and NOT just their username.
I want it to not let them enter anything unless it has the domain, UK\, infront of their username. Their username could be any length.
e.g. UK\jsmith is a valid entry, just jsmith is not
Hence the reason why i went down the custom data validation route (but any other solutions would be greatly appreciated.
I would just re-design the form personally but as i have just come onto a project late on there is no chance they will do this
Anyway, thanks for your help in advance!!
Highlight A2:A100
Data validation:
Allow: Custom
Formula: =ISNUMBER(SEARCH("uk\",A2))
Add your custom error alert messages.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Re: Custom data validation??
JBeaucaire, you are a genius!! It works a treat!
And don't let anybody else tell you otherwise...
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks