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

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

Hi, there are a number of good posts on 'date validation' at the
following groups:
http://groups-beta.google.com/group/...t.public.excel
http://groups-beta.google.com/group/...el.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.

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





"swisse" escreveu na mensagem
...
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

How did you write your macro or your formula?

Swisse