Vba string length

MsgBox Len("Helloworld !")     ' 12

Vba string length

Dim myString as String
Dim arr() as String
Dim str_len as Integer

myString = "Come visit Mzansi over the holidays"
arr = Split(myString, " ")
'Compute string length i.e number of 'words'
str_len = UBound(arr) - LBound(arr) + 1

Similar codes

0 vote178 views1 answer
Loop through lines in text file vb net
VBA
1 vote175 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
4 votes184 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote176 views1 answer
Excel vba range contains
VBA
0 vote200 views1 answer
Excel vba move down to next visible cell
VBA
0 vote184 views1 answer
Vba code to select image in sheet
VBA
-1 vote186 views2 answers
Excel vba delete empty rows
VBA
8 votes285 views1 answer
Excel vba determine number of elements in a 1D array
VBA
8 votes208 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote181 views1 answer
Excel R1C1 mode
VBA