Vba string

Dim text1 As String
text1 = "Hello"
text1 = text1 & " World"
Debug.Print Left(text1, 3) 			' Hel
Debug.Print Right(text1, 4) 		' orld
Debug.Print Mid(text1, 2, 3)		' ell
Debug.Print Len(text1)				' 11	(size)
Debug.Print Instr(text1, "World")	' 6    	(position in text1)

Similar codes

2 votes336 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote332 views1 answer
Loop through each cell in dgv vbnet
VBA
3 votes316 views1 answer
Excel vba change format of cell
VBA
0 vote332 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote318 views1 answer
Excel vba join variant array
VBA
0 vote305 views1 answer
Vbs send keys
VBA
3 votes337 views1 answer
Vba make long from two words
VBA
4 votes310 views1 answer
Excel vba check cell not empty
VBA
0 vote318 views1 answer
Vbs expand env var
VBA
0 vote343 views1 answer
Create links in msgbox in vb
VBA