VBA Convert Number To String, we use CStr data type conversion VBA function. The number can be integer, or any numeric value. In the following article let us see an example. And also see the step by step instructions to run VBA code in the visual basic editor(VBE) window. You can find link at the end of the session to know more about CStr VBA function.
Let us see an example VBA macro code how to convert number to string.
'VBA Convert Number to Function Sub VBAF1_Convert_Number_to_Function() 'Variable Declaration Dim iNum As Integer, sResult As String 'Assign value to variable iNum = 100 'Check given input value is number or not If IsNumeric(iNum) Then sResult = CStr(iNum) MsgBox sResult, vbInformation, "VBAF1" Else MsgBox "Enter valid number.", vbInformation, "VBAF1" End If End Sub
Explanation: First we are checking given input value is numeric or not.To check we are using IsNumeric VBA function. This function is a VBA information function. Once we are done with checking, if it is numeric value then converting number to a string value. Run this code in debug mode. Stop at msgbox as shown in the following screen shot. Put cursor on iNum and then notice given input value has converted to string. It is in double quotes.
You can refer the following link for the step by step instructions.
Click on the following links of the useful resources. These helps to learn and gain more knowledge.