Search string for double quotes

Question

When looking for double quotes using Instr I know that you need to use 4 double quotation marks to search for a string Instr(String,""""), or alternatively Instr(String, Chr(34)). I don't quite understand why 3 double quotes don't workInstr(String,""")

I have Googled for this, but have not found the answer I'm looking for. I understand that this is a very simple question, but it seems that I can’t think about it.

Answer 1

""Just quoting "- therefore """means "_here comes a double quote- and VBA is not enough closure "!

In other words:

• x = "" → Content is not filled
• x = """" → Content x is "
• x = """ → VBA , ( "), ("") - "...