Macro to trigger Data Validation

**amdk8800** · 12-22-2010, 03:39 AM

Hello Experts,

Could you tell me how to trigger a Data Validation to be perform on a particular cell through VBA? This validation is not triggered if the cell value is changed via a macro.

This is my exact situation if the above is not clear enough:

I have a Calendar Form which allows user to click on a date and it inserts the date into a cell. This cell has a validation rule against it, which displays an error message if it does not satisfy certain conditions (what they are is not important). This works fine if the date is inserted by key. However, if the the value is inserted by the Calendar Form (through a macro), the cell gets populated bypassing the data validation rule of the cell. I understand that one can use code to check if the cell conform to the conditions in the first place before insertion, but I don't want to hard code the error message somewhere inside my VBA script. Is there a method to trigger the validation to run?

Thanks guys in advance.
Fan

**Bob Phillips** · 12-22-2010, 04:42 AM

Just perform the same check in VBA and output a MsgBox if it fails.

**amdk8800** · 12-22-2010, 05:02 AM

Hi Bob, The thing is my macro can be used to insert a value to different cells (depends on which cell is selected when run) and they have different validation conditions. I want my script to be as general as possible and not hard-code any conditions and messages.