/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

22 votes356 views1 answer
Xl vba check for folder
VBA
1 vote177 views1 answer
Vba exit do while
VBA
0 vote239 views1 answer
Vba cell all borders
VBA
0 vote195 views1 answer
Excel vba linter
VBA
0 vote225 views1 answer
VBA Loop to range
VBA
0 vote208 views1 answer
Add items to combobox vb.net
VBA
2 votes221 views1 answer
Vba file from path
VBA
0 vote239 views1 answer
Weekday vba
VBA
5 votes238 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote226 views1 answer
Excel vba unlock sheet without password
VBA