/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 vote155 views1 answer
Excel vba current folder
VBA
0 vote138 views1 answer
How to self delete a vbscript file
VBA
1 vote155 views2 answers
Vba function return array
VBA
0 vote165 views1 answer
Set column width of datagridview vb.net
VBA
0 vote191 views2 answers
Get unique random number in vb.net
VBA
0 vote160 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote149 views1 answer
Excel vba populate array with cell values
VBA
3 votes193 views2 answers
Vba date to string
VBA
6 votes160 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote179 views1 answer
Vba round to 2 decimals
VBA