How to use the CStr Function (VBA)

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

SUMMARY:

The Excel VBA CStr function converts an expression into a String data type.

For example,

• The VBA Code CStr("Hello") would return "Hello"
• The VBA Code CStr(33.955555) would return "33.955555"

PURPOSE:

To converts a value to a String.

RETURN VALUE:

The CStr function returns a String value.

REMARKS:

• The CStr function can only be used in VBA code in Microsoft Excel.
• The CStr Function can convert different types of expression (Integer, Boolean and Date) into String data types
• You can use the CStr function if you want to return a numerical values as a string.
• The Single data type is a Value data type.
• VBAs hexadecimal notation symbol is "&H"

CStr Function VBA Code example:

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

CStr Function Example (as VBA code)

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

Dim TestCase As Single
TestCase = CStr(253.3567812)

In the above example, CStr(253.3567812) would return the String value "253.3567812", the variable called TestCase would now contain the String Data Type value "253.3567812"

VBA CStr Function Error:

If you supply the CStr function with input value which is outside the range of the data type being converted to, you will get the error:
Run-time error '6': Overflow

---

---

Download Example Sample Excel File

CStr-function-example.xlsm

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