/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

8 votes489 views1 answer
Vba convert 2 bytes to an integer
VBA
1 vote320 views1 answer
Vbscript convert ascii code to character
VBA
3 votes367 views1 answer
Vba post request json
VBA
0 vote355 views1 answer
Build an index all files of a FTP site
VBA
32 votes529 views2 answers
Excel vba column letter
VBA
0 vote339 views1 answer
Excel text to columns line break
VBA
0 vote343 views2 answers
Excel vba copy paste after last row
VBA
1 vote342 views1 answer
Excel vba saveas force overwrite
VBA
0 vote342 views1 answer
Make all controls in an area not visable vb
VBA
0 vote342 views1 answer
Vbnet chart make 0 gridline line different color
VBA