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

1 vote331 views1 answer
Export datagridview to excel vb.net
VBA
0 vote325 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote347 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote324 views1 answer
VBA Sleep Snippet
VBA
0 vote323 views1 answer
Write listbox to text file vb.net
VBA
0 vote310 views1 answer
How to extract a file from an ISO:
VBA
3 votes315 views1 answer
Vba request json
VBA
0 vote342 views1 answer
Excel vba named range exists
VBA
1 vote315 views1 answer
Excel format cell as kilowatts
VBA
0 vote322 views1 answer
Vbnet hex to binary
VBA