/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

4 votes318 views1 answer
Excel vba determine number of elements in an array
VBA
5 votes357 views1 answer
Excel-vba get integer high byte
VBA
0 vote319 views1 answer
Vba range clear formatting
VBA
0 vote324 views1 answer
Excel vba prevent saving workbook
VBA
1 vote324 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote307 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote322 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote317 views1 answer
Vba compare strings
VBA
1 vote292 views2 answers
Excel vba password protect
VBA
3 votes302 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA