VBA宏替换问题:如何用ChrW(&H2713)勾选符号替代字母L?
VBA常量替换问题解答
我找到一个可在指定范围内将字母替换为某一字母、数字替换为另一字母的VBA宏,代码如下:
Public Const Letters As String = "abcdefghijklmnopqrstuvwxyz" Public Const Numbers As String = "0123456789" Public Const FoundLetter As String = "L" Public Const FoundNumber As String = "N"
该宏运行正常,但我希望用勾选符号(ChrW(&H2713))替代字母L,请问应将As String = "L"改写为哪一行代码?
将原来的Public Const FoundLetter As String = "L"替换为:
Public Const FoundLetter As String = ChrW(&H2713)
内容的提问来源于stack exchange,提问作者jkp
相关产品推荐
相关产品推荐

