Hi All

I have created employee template to be distributed to all my company
officess in my country. Each of the office need to fill the employee info.

I have created a button to validate all data like emp code, date, email ids,
etc. via VBA code.After entering all data, they need click on this button to
check data validation for no errors.

There is one colum Department, where i have given validation list in excel
to select respective Department. But if the user copy and paste data in the
template, the validation allows to paste those department not in the
validation list.

How to catch this as an error using VBA code on my macro button itself??

Thanks
Regards
Seema