/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 vote182 views1 answer
Create new worksheet excel visual basic
VBA
18 votes328 views2 answers
Vba make word from bytes
VBA
1 vote148 views1 answer
If inputbox cancel vba
VBA
0 vote155 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote152 views1 answer
Vb check if row has column
VBA
0 vote145 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote151 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote152 views1 answer
Vba string
VBA
1 vote150 views2 answers
Get all column names from excel vba
VBA
0 vote151 views1 answer
Vb get ip address
VBA