Question : vba string length
Answered by : vastemonde
MsgBox Len("Helloworld !") ' 12Source : | Last Update : Mon, 08 Feb 21
Question : vba string length
Answered by : oldfashioned-opossum-5rqjt7sjws3j
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) + 1Source : | Last Update : Tue, 19 Jan 21