Results 1 to 5 of 5

Thread: type of data

  1. #1
    Join Date
    Apr 2006
    Posts
    47

    Unanswered: type of data

    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?

  2. #2
    Join Date
    Apr 2006
    Posts
    47

    Instantiate new class

    ooooooooooooooooopssssss
    Last edited by MikeroSoft; 06-20-06 at 11:45.

  3. #3
    Join Date
    Jun 2006
    Location
    Colton, CA
    Posts
    26
    I guess the oops means you've worked it out?
    Geek it till it mHz

  4. #4
    Join Date
    Apr 2006
    Posts
    47
    no, i posted my next post as an answer and dont know how to delete a post

  5. #5
    Join Date
    Jun 2006
    Posts
    103
    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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •