Is it possible to create an error message when duplicate text is entered in to a column? For example, cell A1 contains the text AS-HG-001. If that text is entered again anywhere in column A I want an error message to pop up that sais "Item already entered" and not allow the user to enter the duplicate text.
you could probably do this with conditional formatting, and make it change color?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello
As an alternative, maybe use a Custom Data Validation formula, for example:
Here it's applied to the range A2:A20. You can insert whatever error message you require.
Please Login or Register to view this content.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks