/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

1 vote192 views1 answer
Excel date to unix timestamp
VBA
0 vote204 views1 answer
Vba multiple optional arguments
VBA
3 votes181 views1 answer
Excel vba get the workbook full file name with path
VBA
1 vote191 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote188 views1 answer
Vba find sub dictionary
VBA
32 votes415 views2 answers
Excel vba column letter
VBA
0 vote194 views1 answer
Write listbox to text file vb.net
VBA
0 vote177 views1 answer
Add items to combobox vb.net
VBA
0 vote186 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote186 views1 answer
Vbs
VBA