Answers. I find the easiest way is to double up on the quotes to handle a quote. *Note CHAR is used as an Excel cell formula, e.g. writing “=CHAR ” in a cell, but for VBA code you use the CHR function. Another work around is to construct a string with a temporary substitute character..Include single quotation marks Include double quotation marks Have questions or feedback about Office VBA or this documentation? Please .In VBA, strings assigned to variables or properties are enclosed in double quotes “”, Sometimes you might want to place Double Quotes “” in a string in Excel VBA. In VBE, you can replace ” with “”, and then enclose the entire string =IF B=””Excel””,B,”””” in double quotes “”..Re VBA . The way I like is to include chr , which is the double quote. For example,. str = chr “There should be a double quote before .
0 Komentar