/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

0 vote126 views1 answer
Vba collection key list
VBA
0 vote136 views1 answer
Vba type
VBA
0 vote131 views1 answer
Vba collection contains
VBA
0 vote125 views1 answer
Vba add month to date
VBA
4 votes123 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote126 views2 answers
Excel vba close without saving
VBA
1 vote144 views2 answers
Excel vba password protect
VBA
1 vote131 views1 answer
Vba date to unix timestamp
VBA
0 vote144 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote169 views1 answer
How to call gcd in vba
VBA