Irish_Griffin
Board Regular
- Joined
- Jan 16, 2009
- Messages
- 138
Hi Forum,
Great news, just landed a decent vba gig, looks like I'll be coming back to the community ! Been a while.
So I'm already in trouble... lol, ahhhh VBA, I remember this. lol
I've got an on change event that test to make sure the user puts in an actual date.
The cell it's testing is formatted as a date.
when the user puts in gibberish, the cell reads ################
When "###############" goes through my code it throughs an over flow error.
How can I test for this ################# condition ?
Thanks,
Griff
Great news, just landed a decent vba gig, looks like I'll be coming back to the community ! Been a while.
So I'm already in trouble... lol, ahhhh VBA, I remember this. lol
I've got an on change event that test to make sure the user puts in an actual date.
The cell it's testing is formatted as a date.
when the user puts in gibberish, the cell reads ################
When "###############" goes through my code it throughs an over flow error.
Code:
If Me.Cells(Target.Row, Target.Column).Value <> "" And IsDate(Me.Cells(Target.Row, Target.Column).Value) = False Then
MsgBox "not a date"
End If
How can I test for this ################# condition ?
Thanks,
Griff