/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 vote180 views1 answer
Vba range clear formatting
VBA
0 vote178 views1 answer
Excel vba ternary
VBA
0 vote176 views1 answer
Excel vba prevent saving workbook
VBA
0 vote187 views1 answer
For each item in folder outlook vba
VBA
8 votes194 views1 answer
Run command pormpt in background windows
VBA
1 vote184 views1 answer
Set font for ms chart vb.net
VBA
0 vote181 views1 answer
Arq linux
VBA
0 vote174 views1 answer
Vba collection contains
VBA
0 vote175 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote187 views1 answer
Excel vba textbox forecolor disabled
VBA