Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Verifying Date Format in Excel 1

Status
Not open for further replies.

Bass71

MIS
Jun 21, 2001
79
Hello again:

This simple syntax question is dogging me...

I am trying to determine if a cell value is a date, but I cannot find the syntax. Among others I have tried:

If IsDate(ActiveCell) Then...

Thanks so much................RO
 
Bass71,

Try:

If Vartype(ActiveCell.Value) = vbDate Then
....
End If


Let me know if that does the trick for you!



VBAjedi [swords]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top