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 vote160 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote200 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote176 views1 answer
Write listbox to text file vb.net
VBA
1 vote166 views1 answer
Excel vba get column name from number
VBA
5 votes111 views1 answer
Vlookup vba
VBA
0 vote188 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote184 views1 answer
If statement vdhl
VBA
0 vote159 views1 answer
Vb get ip address
VBA
0 vote155 views1 answer
Afficher un message d'erreur vba
VBA
0 vote170 views4 answers
How to continue formula in below line in vba code
VBA