/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 vote315 views1 answer
Excel vba disable keyboard input
VBA
0 vote329 views1 answer
Vba test optional argument
VBA
1 vote338 views1 answer
Vb.net get name by Cell Click
VBA
0 vote340 views1 answer
Vba character ascii code
VBA
2 votes306 views2 answers
Constructor vb.net
VBA
0 vote316 views1 answer
Dynamic array vba
VBA
3 votes316 views1 answer
Excel vba change format of cell
VBA
0 vote336 views1 answer
Vba clear collection
VBA
0 vote343 views1 answer
Tester si une case est vide vba
VBA
0 vote306 views1 answer
Vba loop through table
VBA