How to use the CSng Function (VBA)

This Excel tutorial explains how to use the Excel CSng function with syntax and examples using VBA.

SUMMARY:

The Excel VBA CSng function converts an expression into a Single data type.

For example,

• The VBA Code CSng(22426.55) would return 22426.55
• The VBA Code CSng(33.955555) would return 33.9555

PURPOSE:

To converts a value to into Single precision floating point numbers.

RETURN VALUE:

The CSng function returns a Single precision numeric value.

REMARKS:

• The CSng function can only be used in VBA code in Microsoft Excel.
• The Single data type can hold integer values from 1.401298E-45 through 3.4028235E+38 for positive values
• The Single data type can hold integer values from -3.4028235E+38 through -1.401298E-45 for negative values
• The Single data type is a Value data type.
• VBAs hexadecimal notation symbol is "&H"

CSng Function VBA Code example:

Diffrent way to use the CSng function using Excel VBA Code...

CSng Function Example (as VBA code)

The CSng function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CSng function can convert values into Single data types.

Dim TestCase As Single
TestCase = CSng(253.3567812)

In the above example, CSng(253.3567812) would return the Single Data Type value 253.3568, the variable called TestCase would now contain the Single Data Type value 253.3568

VBA CSng Function Error:

If you supply the CSng function with a numeric value that is less than -3.4028235E+38 or greater than 3.4028235E+38, you will get the error:
Run-time error '6': Overflow

If you supply the CSng function with a text String that cannot be converted into a numeric value, you will get the error:
Run-time error '13': Type mismatch

---

---

Download Example Sample Excel File

CSng-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…