/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 vote176 views1 answer
Excel last used row
VBA
0 vote242 views1 answer
Application.ExecutablePath VB.NET
VBA
-1 vote157 views1 answer
For i in range vba
VBA
20 votes337 views1 answer
Excel vba factorial
VBA
0 vote159 views1 answer
Excel vba join variant array
VBA
0 vote172 views1 answer
Excel vba extract year
VBA
0 vote165 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote180 views1 answer
Tester si une case est vide vba
VBA
0 vote169 views1 answer
VBA Sleep Snippet
VBA
0 vote163 views1 answer
Vba open report
VBA