VBA Code to Calculate the Length of a String in Excel

VBA Code:

' VBA Code to Calculate the Length of a String in Excel

Sub CalculateStringLength()
    Dim inputString As String
    Dim stringLength As Integer
    
    ' Prompt the user to enter a string
    inputString = InputBox("Enter a string:")
    
    ' Calculate the length of the string
    stringLength = Len(inputString)
    
    ' Display the result
    MsgBox "The length of the string is: " & stringLength
End Sub


Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment