/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 votes345 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote275 views1 answer
Open application from vbnet
VBA
0 vote279 views1 answer
Vbnet check if number is even or odd
VBA
0 vote319 views1 answer
Excel vba first column in range
VBA
1 vote282 views1 answer
Excel date to unix timestamp
VBA
0 vote280 views1 answer
Vba sheet visible
VBA
6 votes321 views1 answer
Excel vba get the path of current workbook
VBA
1 vote235 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote278 views1 answer
Vbnet get file name from path
VBA
0 vote294 views1 answer
Send webhook vbscript
VBA