Variant Data Type...

Which function should be used to find out the value in a variant data type is being stored internally ?

1) TypeOf
2)DataType
3)VarType
4)ObjectType

Thanks,
bhavesh
bhavesh55Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mr_krishnaConnect With a Mentor Commented:
Use VarType function to get the value of a data type.

This example uses the VarType function to determine the subtype of a variable.

Dim IntVar, StrVar, DateVar, MyCheck
' Initialize variables.
IntVar = 459: StrVar = "Hello World": DateVar = #2/12/69#
MyCheck = VarType(IntVar)   ' Returns 2.
MyCheck = VarType(DateVar)   ' Returns 7.
MyCheck = VarType(StrVar)   ' Returns 8.

0
 
mcriderCommented:
Stop asking test questions!

To everyone else... This guy graded my last CORRECT answer as a "D"... Don't let him bring your grade average down...
0
 
RuchiCommented:
Why D?
0
 
mcriderCommented:
Because testboy has no sense of humor at all... A "D" isn't worth the 5 points... If he graded it at all...

bhavesh55's grade ratio:  14 / 28
0
All Courses

From novice to tech pro — start learning today.