/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

5 votes379 views1 answer
Xlvba double quotes in string literal
VBA
0 vote333 views1 answer
Vba code to open a file with login rights
VBA
8 votes385 views1 answer
Excel vba make integer
VBA
5 votes318 views1 answer
Vba array worksheet.index
VBA
0 vote348 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote339 views1 answer
For each item in folder outlook vba
VBA
0 vote329 views1 answer
Search in richtextbox vb.net
VBA
1 vote364 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote324 views1 answer
Vbnet check if number is even or odd
VBA
0 vote361 views1 answer
Open file dialog in vb.net
VBA