Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VALIDATION IN EXCEL VBA
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VALIDATION IN EXCEL VBA
Resolved · Low Priority · Version 2003
Reply
VALIDATION IN EXCEL VBA
How do you create cell validation in VBA. My basic spreadsheet has validation rules in the sheet. However, on creating a new spreadsheet, the delete data routines clear the validations. Threrefore, I need to create validation rules against a list either on a sheet that is not changed or in the codeFor upcoming training course dates see: Pricing & availability
RE: VALIDATION IN EXCEL VBA
Hi TonyThanks for your question
It is possible to create validation rules in VBA. Simply create a procedure that checks the value of various cells and warns if they don't meet certain criteria, and then set it to run on the worksheet's change event.
Alternatively, in the example you have provided, why not create your workbook with all the validation rules in place and then save it as a template? Then every time you create a new instance of the template all the rules will be in place
Regards
Stephen
|
 |
|
» Forum post: Forms |
How do you limit the text, i.e. number of characters or words, within an answer box in a form? 
