/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 vote122 views1 answer
Compare dates vb
VBA
0 vote113 views1 answer
Vbnet add new ecel sheet
VBA
0 vote141 views1 answer
Vba table header name
VBA
0 vote125 views1 answer
Vbscript check if string is empty
VBA
0 vote120 views1 answer
Excel vba copy range with filter
VBA
0 vote128 views1 answer
Refresh token em vb net
VBA
0 vote125 views1 answer
Excel vba disable alerts
VBA
5 votes137 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote128 views1 answer
Delete rows in excel vba code
VBA
1 vote109 views2 answers
Vba remove first 2 characters from string
VBA