String variable : String « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. String

String variable

 
Sub concat()
    Dim strFirstname As String
    Dim strLastName As String
    Dim strFullName As String


    strFirstname = "John"
    strLastName = "Smith"


    strFullName = strFirstname & " " & strLastName
    Debug.Print strFullName
End Sub








Related examples in the same category

1.String data types are used to hold a sequence of characters in a variable.
2.To initialize a string variable, place the string value within double quotes.
3.An example of a declaration for a fixed length string
4.Concatenate strings
5.String Concatenation with &