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 vote234 views1 answer
Vb ternary
VBA
1 vote215 views2 answers
Vba remove first 2 characters from string
VBA
0 vote235 views1 answer
Vba file chooser
VBA
0 vote235 views1 answer
Excel vba prevent saving workbook
VBA
0 vote234 views1 answer
Vba simple quote
VBA
0 vote216 views1 answer
Putting marquee in vb.net
VBA
0 vote241 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote199 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote237 views4 answers
How to continue formula in below line in vba code
VBA
3 votes206 views1 answer
Excel vba last row in range
VBA