Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to check errors in excel 2002 | Excel Programming | |||
Validation check | Excel Programming | |||
How to check whether Cell has Validation? | Excel Programming | |||
Check validation on SelectionChange | Excel Programming | |||
CODE FOR CHECK BOXES, AND EXCEL AS ATTACHMENT ! | Excel Programming |