/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 vote167 views1 answer
Excel vba disable mouse click
VBA
0 vote168 views1 answer
Limit combobox to list vba
VBA
0 vote169 views1 answer
Vba pass named range to function
VBA
0 vote157 views2 answers
Excel vba prevent save
VBA
0 vote192 views1 answer
Excel vba round to whole number
VBA
0 vote181 views1 answer
Find database connection string vb
VBA
0 vote170 views1 answer
VB Error Code BC30201
VBA
0 vote175 views1 answer
Filesystemobject vba reference
VBA
0 vote154 views1 answer
Vba word pdf table to excel
VBA
0 vote181 views1 answer
.net crash app
VBA