/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 vote202 views1 answer
Vba excel parser xml
VBA
1 vote195 views1 answer
Textbox find and replace vb
VBA
0 vote223 views2 answers
Checking and changing system volume vb.net
VBA
-1 vote187 views1 answer
For i in range vba
VBA
0 vote201 views1 answer
Vba compare strings
VBA
12 votes254 views1 answer
Excel vba write string to text file
VBA
1 vote195 views1 answer
Random number generator vb.net
VBA
1 vote197 views1 answer
Excel vba force recalculation
VBA
0 vote224 views1 answer
Iterate all file in a folder vba
VBA
0 vote195 views1 answer
Vba round to 2 decimals
VBA