/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 vote184 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote156 views1 answer
Enter into cells data grid view
VBA
5 votes165 views1 answer
Excel vba how to unit test vba code
VBA
0 vote185 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote175 views1 answer
Vbnet hex to binary
VBA
0 vote177 views1 answer
Excel text to columns line break
VBA
0 vote171 views1 answer
Excel vba hide gridlines
VBA
4 votes186 views2 answers
Vba create folder if not exist
VBA
0 vote172 views1 answer
.net dark title bar
VBA
0 vote198 views1 answer
Style percent not found vba
VBA