в 16:33, 26 мая 2010

2010-05-26T16:33:00Z

Admin: 1 версия

2010-05-26T12:48:09Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 16:33, 26 мая 2010
(нет различий)

VBA/Excel/Access/Word/Data Type/String - История изменений

в 16:33, 26 мая 2010

Admin: 1 версия