/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 vote310 views1 answer
Vba string
VBA
0 vote274 views1 answer
Vba copy paste value only
VBA
2 votes286 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote309 views1 answer
Excel named range sum
VBA
0 vote275 views1 answer
Vba dictionary length
VBA
0 vote286 views1 answer
Vbnet line chart showing extra space
VBA
4 votes299 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote292 views1 answer
Limit combobox to list vba
VBA
0 vote360 views2 answers
Excel vba store array and write to sheet
VBA
0 vote330 views1 answer
Vbs run with cscript
VBA