如何在vba中的字符串中放置双引号? [英] How do I put double quotes in a string in vba?

问题描述

我想通过包含双引号的 vba 在单元格中插入 if 语句.

I want to insert an if statement in a cell through vba which includes double quotes.

这是我的代码:

Worksheets("Sheet1").Range("A1").Value = "=IF(Sheet1!B1=0,"",Sheet1!B1)"

由于双引号，我在插入字符串时遇到问题.我如何处理双引号?

Due to double quotes I am having issues with inserting the string. How do I handle double quotes?

推荐答案

我发现最简单的方法是将引号加倍以处理引号.

I find the easiest way is to double up on the quotes to handle a quote.

Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)" 

有些人喜欢使用 CHR(34)*:

Some people like to use CHR(34)*:

Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0," & CHR(34) & CHR(34) & ",Sheet1!A1)" 

*注:CHAR() 用作 Excel 单元格公式，例如在单元格中写入=CHAR(34)"，但对于 VBA 代码，您使用 CHR() 函数.

*Note: CHAR() is used as an Excel cell formula, e.g. writing "=CHAR(34)" in a cell, but for VBA code you use the CHR() function.

这篇关于如何在vba中的字符串中放置双引号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！