/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

2 votes178 views1 answer
Excel vba date to string conversion
VBA
0 vote186 views1 answer
Excel vba center userform
VBA
0 vote210 views4 answers
Vgrive,deb
VBA
0 vote162 views1 answer
Enter into cells data grid view
VBA
0 vote173 views1 answer
Excel vba hide columns
VBA
0 vote206 views1 answer
Vba ternary
VBA
0 vote172 views1 answer
Visual basic msdos
VBA
0 vote207 views1 answer
Vba listbox remove all items
VBA
1 vote180 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote180 views1 answer
Excel vba first row in range
VBA