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

5 votes179 views1 answer
Vba low word from Long Integer
VBA
2 votes168 views2 answers
Constructor vb.net
VBA
1 vote211 views1 answer
Excel vba get column number from column name
VBA
0 vote188 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote181 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote177 views1 answer
Excel VBA web scraping
VBA
0 vote170 views1 answer
Vba first line of string
VBA
2 votes168 views1 answer
Excel vba date to string conversion
VBA
0 vote175 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote156 views1 answer
Excel vba current folder
VBA