Shen JinWei
Shen JinWei
Programming language:VBA
2021-03-25 02:40:08
0
Q:

VBA check if a cell contains a letter or string

Xiaolong
Xiaolong
Code: VBA
2021-09-27 05:17:38 
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
0

Tags

Related

New to Communities?

Join the community