I understand what a variant just thought that if you were passing a variable to a function and it excpected a variable of type variant that it had to explicitly declared as type variant (until now ). I imagine I didn't understand you're question the first time. Anyway I looked through and couldn't find any functions that would just check for just date values. I imagine you could write your own IsTime function and use it in conjunction with the IsDate function to keep users from entering the wrong data.

Code:
If (IsDate(stext)) And (IsTime(stext) = False) Then
Good Luck!