hi friends

i have used a calender control in my excel sheet from which i fetch a date into a cell where i have given a data vallidation which does not work.
but if i directky edit in the cell it works.

pls help me how to invoke the validate message through code.

brgds
arun