VBA CLng function

CLng Function Description

The VBA CLng function converts an expression (variable) to CLng data type.


The syntax for the CLng function in VBA is:

CLng( expression )


An expression / variable that is to be converted to Long data type.

Other Notes

If the expression / variable can’t be converted to a Long, the function with return Error code 13: Type mismatch.

Example usage

The CLng function can be used in VBA code. Let’s look at some VBA CLng function examples:

CLng 10
'Result: 10

CLng 10.6 
'Result: 11

CLng "20"
'Result: 20