Check Validation via Excel VBA code.
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 |
Check Validation via Excel VBA code.
have your code check the entry against a list of valid departments.
-- Regards, Tom Ogilvy "Seema" wrote: 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 |
Check Validation via Excel VBA code.
Thanks Tom for willing to help me.
No. How to check that using VBA Code? I am not able to write that code to cross check the entry against the validation list. Please help me.. "Tom Ogilvy" wrote: have your code check the entry against a list of valid departments. -- Regards, Tom Ogilvy "Seema" wrote: 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 |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com