/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 vote242 views1 answer
Vba extract filename from path
VBA
0 vote239 views1 answer
Excel vba delete folder
VBA
1 vote220 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote246 views1 answer
Excel vba protect scenarios
VBA
2 votes223 views1 answer
Date format for ms chart vb.net
VBA
2 votes265 views2 answers
Excel vba if sunday or staurday
VBA
0 vote237 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote241 views1 answer
Vba excel parser xml
VBA
0 vote253 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote237 views1 answer
Excel vba remove formatting from cell
VBA