/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

5 votes188 views1 answer
Vba array worksheet.index
VBA
0 vote232 views1 answer
Excel vba first column in range
VBA
3 votes228 views1 answer
Vba continue for each loop
VBA
0 vote241 views1 answer
How to enter Vbox manage commands
VBA
1 vote150 views1 answer
Ms access open form to new record
VBA
6 votes230 views1 answer
Excel vba isalpha
VBA
0 vote227 views1 answer
Excel vba convert cells address
VBA
0 vote227 views1 answer
Return na vba
VBA
18 votes384 views3 answers
Excel-vba make integer
VBA
1 vote207 views1 answer
Excel vba get column name from number
VBA