Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have a cell on my worksheet that relies on cell validation. If the user enters an invalid entry, the error dialogue box is displayed. They are given three options: Retry, Cancel, or Help.
1) If they select help, it loads up a Microsoft website offering validation help. Not really helpful to the user who erred in data entry. Can this Help button be customized?
2) If the user selects Cancel, any code associated with the change event of that cell in which an invalid entry was made triggers. This of course leads to an error because the code relies on a valid entry in that cell. What does one do to ensure that cancel doesn't advance the code.
Can the CANCEL and HELP buttons be removed?
1) If they select help, it loads up a Microsoft website offering validation help. Not really helpful to the user who erred in data entry. Can this Help button be customized?
2) If the user selects Cancel, any code associated with the change event of that cell in which an invalid entry was made triggers. This of course leads to an error because the code relies on a valid entry in that cell. What does one do to ensure that cancel doesn't advance the code.
Can the CANCEL and HELP buttons be removed?