/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 vote233 views1 answer
Vb streamreader
VBA
0 vote237 views1 answer
Vba add month to date
VBA
-1 vote270 views1 answer
Code for reading letters only in vb 6
VBA
22 votes313 views1 answer
Excelvba check for directory
VBA
5 votes284 views1 answer
Excel vba get low byte from INTEGER
VBA
5 votes248 views1 answer
Vba low word from Long Integer
VBA
0 vote264 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote240 views1 answer
Vba like with wildcard
VBA
0 vote246 views1 answer
VBA is form loaded
VBA
0 vote241 views1 answer
Excel vba protect content
VBA