/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

8 votes289 views1 answer
Excel vba make word
VBA
0 vote221 views1 answer
Excel run macro every 5 minutes
VBA
0 vote205 views1 answer
Style percent not found vba
VBA
2 votes208 views2 answers
Excel vba copy values range to another range
VBA
0 vote250 views1 answer
How to enter Vbox manage commands
VBA
0 vote212 views1 answer
Get current url vb.net
VBA
8 votes302 views1 answer
Vba make integer
VBA
5 votes237 views1 answer
Excel-vba get integer high byte
VBA
0 vote236 views1 answer
Vba multiple optional arguments
VBA
3 votes250 views2 answers
Vba date to string
VBA