/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 vote146 views1 answer
Vba get relative cell address
VBA
0 vote159 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote155 views1 answer
Vbnet find highest value in chart
VBA
1 vote148 views1 answer
Add control vb
VBA
0 vote171 views1 answer
Excel vba named range exists
VBA
0 vote151 views1 answer
Loop through each cell in dgv vbnet
VBA
15 votes212 views1 answer
Excel vba wait
VBA
3 votes159 views1 answer
Vba continue for each loop
VBA
0 vote153 views1 answer
Vba run command
VBA
0 vote170 views1 answer
Excel vba paste all to each sheet in workbook
VBA