How Do I Convert an Integer to a String in Excel VBA?

CStr(45) is all you need (the Convert String function)

Try the CStr() function

Dim myVal as String;
Dim myNum as Integer;

myVal = "My number is:"
myVal = myVal & CStr(myNum);