Excel VBA CVar Function

VBA CVar Function: The CVar function in VBA converts an expression into a Variant data type.

Syntax

CVar (Expression)

Parameter

Expression (required) – This parameter represents the expression that that you want to convert to a Variant data type wherein it can hold numeric, string, or date values.

Return

This function returns a variant value after converting the supplied expression into a Variant data type.

Example 1

Sub CVarFunction_Example1()
 ' Converting an Integer, a String or a Date into Variants
 Dim var As Variant
 var = CVar(100)
 ' The variant var will return 100
 Cells(1, 1).Value = var
 End Sub 

Output

100

Example 2

Sub CVarFunction_Example2()
 ' Converting an Integer, a String or a Date into Variants
 Dim var As Variant
 var = CVar("Hello VBA")
 ' The variant var will return Hello VBA
 Cells(1, 1).Value = var
 End Sub 

Output

Hello VBA

Example 3

Sub CVarFunction_Example3()
 ' Converting an Integer, a String or a Date into Variants
 Dim var As Variant
 var = CVar(#10/10/2020#)
 ' The variant var will return Hello VBA
 Cells(1, 1).Value = var
 End Sub 

Output

10/10/2020