How I do to validate a date?

[Marcelo]

How I do to validate a date -> example 29/2 with a formula or with VBA.
Thanks in advance

 

[Guest]

Why don't you try:
If IsDate(Activecell) Then
' write some code here that Excel will execute once it has validated it
is a date
End If

 

[Lonnie M.]

Hi, there are a number of good posts on 'date validation' at the
following groups:
http://groups-beta.google.com/group/microsoft.public.excel
http://groups-beta.google.com/group/microsoft.public.excel.programming

Give them a look, they should get you pointed in the right direction.
If you get stuck there will be plenty of people around to answer your
question. HTH--Lonnie M.

 

[Marcelo]

This don't work -> If IsDate(Activecell) Then
with "29/2"

 

[Guest]

How did you write your macro or your formula?

Swisse