The VBA CStr function converts an expression into a String data type.
The syntax of the function is:
Where the Expression argument is the expression that that you want to convert to a String.
The following VBA code shows how the CStr function can be used to convert different types of expression (Integer, Boolean and Date) into String data types.
|
' Convert Integer, Boolean and Date expressions into Strings
Dim str1 As String
Dim str2 As String Dim str3 As String
str1 = CStr( 10 )
' str1 is now equal to the string "10"
str2 = CStr( True )
str3 = CStr( #1/1/2016# )' str2 is now equal to the string "True" ' str3 is now equal to the string "1/1/2016" |
After running the above VBA code, the variables str1, str2 and str3 are equal to the strings "10", "True" and "1/1/2016" respectively.