/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 vote144 views1 answer
Excel vba chrw max value
VBA
0 vote149 views1 answer
Excel R1C1 mode
VBA
0 vote143 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
3 votes159 views1 answer
Vba post request json
VBA
0 vote164 views1 answer
Vba count all row
VBA
2 votes102 views1 answer
Excel vba pause
VBA
-1 vote143 views1 answer
For i in range vba
VBA
0 vote146 views1 answer
Vb check if row has column
VBA
1 vote144 views2 answers
Vba string to date
VBA
7 votes169 views1 answer
Excerl vba array to range
VBA