/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 vote170 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote212 views1 answer
Vb ternary
VBA
0 vote199 views1 answer
Delete all controls in an area vb
VBA
0 vote186 views1 answer
Date as number vb
VBA
5 votes202 views1 answer
Excel vba last byte from INTEGER
VBA
2 votes174 views2 answers
Excel vba copy values range to another range
VBA
1 vote179 views1 answer
How to check is the value enterd is a number or text in vba
VBA
8 votes332 views1 answer
Vba make a short integer from two bytes
VBA
0 vote182 views1 answer
Vb test if reference is null
VBA
0 vote184 views1 answer
Vbnet line chart showing extra space
VBA