/VBA/VBA check if a cell contains a letter or string

VBA check if a cell contains a letter or string

Sub IfContains()
    If InStr(ActiveCell.Value, "string") > 0 Then
        MsgBox "The string contains the value."
    Else
        MsgBox "The string doesn't contain the value."
    End If
End Sub

-1

Source: excel.officetuts.net

Similar codes

32 votes493 views2 answers
Excel vba column letter
VBA
0 vote204 views1 answer
Vba type
VBA
0 vote224 views1 answer
Vba character ascii code
VBA
5 votes210 views1 answer
Xl vba double quotes in string literal
VBA
0 vote210 views1 answer
Vba format currency
VBA
0 vote212 views1 answer
Vba apostrophe chr
VBA
0 vote191 views1 answer
Vba first cell in range
VBA
0 vote184 views1 answer
Remove frist letter from string vbnet
VBA
0 vote199 views1 answer
Visual basic msdos
VBA
6 votes223 views1 answer
Excel vba isalpha
VBA