VBA/Excel/Access/Word/Data Type/String
Содержание
[убрать]An example of a declaration for a fixed length string
Sub Fixed()
Dim myString As String * 8
Dim myNum As Integer
myString = "ABCDEFGHIJKL"
End Sub
Concatenate strings
Sub cmd()
Dim lastName As String
Dim firstName As String
firstName = "first"
lastName = "last"
Debug.Print lastName & ", " & firstName
End Sub
String Concatenation with &
Sub str1()
string1 = "5"
string2 = "5"
newStr = string1 & string2
End Sub
String data types are used to hold a sequence of characters in a variable.
Sub str()
Dim myString As String * 10
Dim myString2 As String
myString = "Fred Flintstone"
myString2 = "Fred Flintstone"
End Sub
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
To initialize a string variable, place the string value within double quotes.
Sub AssignValueString()
Dim myText As String
myText = "VBA is fun"
End Sub