run a macro with data validation?

Hi all
Is it possible to run a macro with data validation?
Tahnks

If you insert data into a cell using macros, this will bypass any cell validation. The key is to code your macro to check it from there too, effectivly having 2 means of validation - one for directly editing the cell and one for data passed by a macro.

Originally Posted by widemonk

If you insert data into a cell using macros, this will bypass any cell validation. The key is to code your macro to check it from there too, effectivly having 2 means of validation - one for directly editing the cell and one for data passed by a macro.

Hi Widemonk!

Thanks for your help.