Zuid-Holland
07-11-2005, 01:15 PM
Hey VBA-crackers,
I need some help!
I need to check if a certain cell (or range) has valid date value, how do i do it?
To elaborate further, i make my column, say column B, as format = date. The user is free to input anything in this column -- he may even copy some data from other column onto it, thus, erasing the date format. Now, i click validate button to check if this column B values are valid date values.
Tried with IsDate function, but wrong results.
Anyone please help me out with this .....
Thanks a ton!
Regards.
I need some help!
I need to check if a certain cell (or range) has valid date value, how do i do it?
To elaborate further, i make my column, say column B, as format = date. The user is free to input anything in this column -- he may even copy some data from other column onto it, thus, erasing the date format. Now, i click validate button to check if this column B values are valid date values.
Tried with IsDate function, but wrong results.
Anyone please help me out with this .....
Thanks a ton!
Regards.