[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel Data Validation

Posted on 2011-05-11
Medium Priority
Last Modified: 2012-05-11
I have an excel sheet that looks for a valid project code between 10 and 12 numbers long.  This works great BUT a user has come back to me and noticed that if you ENTER the code wrong you have to navigate away from the cell before you can enter another code or else you get the SAME error.

I have put a error MESSAGE stating  WARNING:  YOU MUST CLEAR INCORRECT FIELD AND MOVE TO ANOTHER FIELD BEFORE ENTERING AGAIN.     Is this really how data validation should work?

Question by:RichardH1976
  • 2
LVL 12

Expert Comment

ID: 35738479
Tell him to hit the "Esc" key after getting the error message. This way he wont have to goto another cell and come back again.
LVL 12

Accepted Solution

sstampf earned 2000 total points
ID: 35738495
You can enetr a message saying "Wrong Input. Hit Esc and try again"

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question