/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 vote244 views1 answer
Vba optional
VBA
0 vote231 views1 answer
Ribbon show/hide
VBA
13 votes500 views2 answers
Vba write text file
VBA
1 vote211 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote215 views1 answer
How to use VBA to add new record in MS Access?
VBA
6 votes234 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote261 views1 answer
Vba cell all borders
VBA
1 vote253 views1 answer
Find and replace textbox
VBA
0 vote228 views1 answer
Excel vba cell on change
VBA
4 votes228 views2 answers
Vba create folder if not exist
VBA