VALIDATION IN EXCEL VBA

Hi Tony

Thanks 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