validation does not work

[Jack Zhong]

If I input cell's value with VBA codes, the validation rules contained
in the cell would probably not work, are there any other ways to make
the validation works when I set its value outside the sheet?

Thanks,

Jack

 

[Alan]

AFAIK Data Validation will only work if a value is entered into the relevant
cell and entered by hitting 'Enter'
Regards,
Alan.

 

[Jack Zhong]

Alan brought next idea :

AFAIK Data Validation will only work if a value is entered into the relevant
cell and entered by hitting 'Enter'

What a pity!