Results 1 to 7 of 7

Thread: Determine Variant Data Type (wrt Hard Data Types) [Resolved]

Threaded View

  1. Apr 8th, 2006, 01:31 AM #1
    Napoleon
    Napoleon is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2006
    Posts
    159

    Determine Variant Data Type (wrt Hard Data Types) [Resolved]

    Hi,

    I am using a variant parameter in a function to simplify my UI for a control. When that funciton is called, the variant parameter will either be a string or a long. I need to determine which has been passed.

    (One problem is that a string argument can begin with a number, so that rules out using the VAL function.)
    (Since the argument is not an object, I cannot use the IS operator.)

    How can I determine the data type of the variant within the function?


    Cheers,
    Nap.
    Last edited by Napoleon; Apr 8th, 2006 at 02:55 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width