/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 vote134 views1 answer
Vb window.minimize
VBA
0 vote153 views1 answer
Excel vba set cell value to empty
VBA
1 vote139 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote143 views1 answer
Vba type
VBA
3 votes185 views2 answers
Excel "vba" match last value
VBA
0 vote136 views1 answer
Vba first line of string
VBA
0 vote164 views1 answer
Create new worksheet excel visual basic
VBA
15 votes179 views1 answer
Excel vba wait
VBA
3 votes152 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote147 views1 answer
Vba min
VBA