[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

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
0
bhavesh55
Asked:
bhavesh55
  • 2
1 Solution
 
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
 
mr_krishnaCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now