Check whether text in cell contains "?"

  • Thread starter Thread starter H@C0
  • Start date Start date
H

H@C0

Hi,
How can I check with a macro script if the text in a cell contains a
question mark?
Thanks in advance for any tip or hint.
Hans
 
Use the InStr() function. Example below will tell you if there's a ? in the
text in cell A1 of the active sheet.

Sub HasQuestionMark()
If InStr(Range("A1"), "?") Then
MsgBox "Found question mark"
Else
MsgBox "No question mark here!"
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check if a cell contains a number, not text 2
Excel VBA 0
Excel If a Cell Contains a Certain Text (From Another Table) 0
select all cell containing any formula and not text or number 2
A way to count cells in a range containing text or formulas 2
Clip art in Excel 2007 2
Excel Sum numbers in cells that also contain text 34
Excel Count Cells That Contain Text With "?" 0

Back
Top