When using Data validation the standard error message comes up as:
"Retry" "Cancel" "Help"
Is it possible to only allow "cancel" or better still would be for the macro to automatically cancel after giving a message "Invalid data entry, please re-enter correct data"?
With only an "OK" button as an option.
Thank you.
Yoepy
What's the validation criteria?
What cell(s) have the validation?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I have a range of cells that can only accept data that is included in the "ValidCodes" range (which is on a different sheet)
So; Allow:List Source:=ValidCodes
Why would you need to change how this works now? If you enter the wrong stuff, it tells you - if you press escape, you can try again?
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
There is a separate macro that registers key strokes, so if the user hits "Retry", it gets counted again. Hence I want to eliminate the choice. If it was only me using it, it would not be a problem.
I assumed it was a range of cells.Originally Posted by Yoepy
Try this.
- Right-click on the sheet tab that has the validation range needed
- Select View Code from the pop-up context menu
- Paste the code from below in the worksheet's code module
- Change the Range (red) to your validation range of cells.
Please Login or Register to view this content.
Thanks AlphaFrog. I was coming at the problem from the wrong direction. That is very logical.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks