/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

2 votes192 views1 answer
Excel vba extract file name
VBA
8 votes240 views1 answer
Vba make integer
VBA
0 vote224 views1 answer
Group controls programmatically vb
VBA
0 vote220 views1 answer
Prive sub enter clicked vb
VBA
0 vote229 views1 answer
Sort dictionary by key vba
VBA
1 vote208 views1 answer
Excel vba make cell visible
VBA
0 vote206 views1 answer
Hello world vb.net
VBA
0 vote190 views1 answer
Vba apostrophe chr
VBA
0 vote202 views1 answer
Excel vba address not absolute
VBA
0 vote203 views1 answer
Vba loop through table
VBA