vba: isDate function
 

I need to check if a cell contains a date value of particular format
(dd/mm/yyyy). It looks like isDate checks only for a date value and not the
format of the date. Is there any other function that i can use to do this.

thanks.

vba: isDate function
 

MsgBox ActiveCell.NumberFormat = "dd/mm/yyyy"

"phil" wrote:

I need to check if a cell contains a date value of particular format
(dd/mm/yyyy). It looks like isDate checks only for a date value and not the
format of the date. Is there any other function that i can use to do this.

thanks.