type of data

MikeroSoft · #1 (**permalink**) 06-20-06, 10:26

I have a function that takes a variant, i would like to check if the param passed is a date, string , int or double, is there a way to do this?

MikeroSoft · #2 (**permalink**) 06-20-06, 10:34

ooooooooooooooooopssssss

spikey_richie · #3 (**permalink**) 06-20-06, 11:18

I guess the oops means you've worked it out?

MikeroSoft · #4 (**permalink**) 06-20-06, 11:47

no, i posted my next post as an answer and dont know how to delete a post

mkggoh · #5 (**permalink**) 06-29-06, 22:22

Quote:

Originally Posted by MikeroSoft

I have a function that takes a variant, i would like to check if the param passed is a date, string , int or double, is there a way to do this?

Try this out

Quote:

Dim para As String
Dim para1 As Integer
Dim variableType As String
para = "a"
para1 = 1

variableType = TypeName(para)
MsgBox variableType
variableType = TypeName(para1)
MsgBox variableType

Internet Services

Web Development

Digital Marketing

Consumer Tech