Learn Excel - Simplify Life with Excel Concepts

Excel CSng Function (VBA)

CSng Function VBA Code

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.

SYNTAX:

CSng( expression )

ARGUMENTS:

The CSng function syntax has the following arguments:

  • expression: Required. The expression is that you want to convert to a Single precision number value.
    • The "expression" can be any value between -3.4028235E+38 and 3.4028235E+38
    • If "expression" is outside the range of the data type being converted to, an error occurs.

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"

Useful Links: Link 1Link 2Link 3Link 4