/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

1 vote347 views1 answer
Add control vb
VBA
5 votes363 views1 answer
Excel vba low byte from INTEGER
VBA
3 votes364 views1 answer
Vba not equal
VBA
2 votes302 views1 answer
Excel vba pause
VBA
1 vote385 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote366 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote338 views1 answer
Vba line feed
VBA
0 vote369 views1 answer
Excel vba protect sheet
VBA
7 votes397 views1 answer
Excerl vba array to range
VBA
0 vote389 views1 answer
Pivot data source not accepting table named range vba
VBA