/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 vote244 views1 answer
Excel vba arrondir
VBA
1 vote260 views1 answer
Close form vba
VBA
0 vote261 views1 answer
Open application from vbnet
VBA
0 vote280 views1 answer
Weekday vba
VBA
0 vote283 views1 answer
Excel VBA web scraping
VBA
0 vote274 views1 answer
Vba check 32 or 64 bit
VBA
8 votes382 views1 answer
Vba convert 2 bytes to an integer
VBA
5 votes306 views1 answer
Excel vba right word from Long Integer
VBA
0 vote336 views2 answers
Excel vba store array and write to sheet
VBA
0 vote301 views1 answer
Move bindingnavigator vb
VBA