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

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

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