/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
Remove series name from legendvbnet
VBA
0 vote255 views2 answers
S yyyy-MM-dd em vb net
VBA
8 votes312 views1 answer
Excel vba make word
VBA
4 votes181 views2 answers
Vba last row
VBA
0 vote233 views1 answer
Type excel.application is not defined vb
VBA
1 vote232 views1 answer
Excel vba last column in range
VBA
0 vote235 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote240 views1 answer
Excel vba hide columns
VBA
0 vote226 views1 answer
How to use VBA to add new record in MS Access?
VBA
25 votes529 views2 answers
Excel vba folder exist
VBA