/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 vote135 views2 answers
Checking and changing system volume vb.net
VBA
3 votes154 views1 answer
Vba continue for each loop
VBA
4 votes137 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote128 views1 answer
Vba variable number of arguments
VBA
0 vote121 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote121 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote128 views1 answer
Vba copy file
VBA
0 vote122 views1 answer
Vbs run with cscript
VBA
0 vote127 views1 answer
String contins in vba
VBA
0 vote117 views1 answer
Vbnet check if sting contians symbols
VBA