VBA/Excel/Access/Word/Data Type/String

An example of a declaration for a fixed length string

   <source lang="vb">

Sub Fixed()

   Dim myString As String * 8
   Dim myNum As Integer
   myString = "ABCDEFGHIJKL"

End Sub

</source>
   
  

Concatenate strings

   <source lang="vb">

Sub cmd()

   Dim lastName As String
   Dim firstName As String
   firstName = "first"
   lastName = "last"
   Debug.Print lastName & ", " & firstName

End Sub

</source>
   
  

String Concatenation with &

   <source lang="vb">

Sub str1()

   string1 = "5"
   string2 = "5"
   newStr = string1 & string2

End Sub

</source>
   
  

String data types are used to hold a sequence of characters in a variable.

   <source lang="vb">

Sub str()

   Dim myString As String * 10
   Dim myString2 As String
   myString = "Fred Flintstone"
   myString2 = "Fred Flintstone"

End Sub

</source>
   
  

String variable

   <source lang="vb">

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

</source>
   
  

To initialize a string variable, place the string value within double quotes.

   <source lang="vb">

Sub AssignValueString()

   Dim myText As String
   myText = "VBA is fun"

End Sub

</source>