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

Материал из VB Эксперт
Перейти к: навигация, поиск

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