/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 vote227 views1 answer
Excel text to columns line break
VBA
0 vote240 views1 answer
Vba string
VBA
0 vote234 views1 answer
Vba compare strings
VBA
0 vote213 views1 answer
Excel protect cells with formulas
VBA
1 vote226 views1 answer
Excel vba close form escape key
VBA
0 vote221 views1 answer
Hello world vb.net
VBA
0 vote224 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote239 views1 answer
Convert unix to date vba
VBA
0 vote252 views1 answer
Excel vba move down to next visible cell
VBA
-1 vote221 views1 answer
Vba code to add new column in table
VBA