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

1 vote319 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
3 votes279 views1 answer
Excel vba read registry key value
VBA
0 vote269 views1 answer
Excel vba populate array with cell values
VBA
0 vote286 views1 answer
Vba option button selected
VBA
0 vote282 views1 answer
How to make a a msgbpx in vbs
VBA
1 vote302 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote314 views1 answer
Excel vba add reference programmatically
VBA
0 vote293 views1 answer
Make all controls in an area not visable vb
VBA
0 vote287 views1 answer
Excel vba address not absolute
VBA
0 vote305 views1 answer
Vba clear collection
VBA