在Excel VBA的立即窗口中显示日语文本 [英] Displaying Japanese text in the Immediate Window of Excel VBA

问题描述

在Excel 2010中，我有一个包含日语文本的工作表.编辑或显示都没有问题.当我获取包含日语的单元格的值并使用Debug.Print在即时窗口中显示它时，它显示为????如果使用浏览器，这将是一个熟悉的问题.我只是确保所有内容都采用UTF-8编码.我在英文Windows上安装了日语，一切正常.在Excel中，我尝试将默认语言设置为日语.我将编辑器字体更改为Arial Unicode，但到目前为止，我仍然收到问号.我联系了微软.我从一个人传到另一个人，但他们无能为力.他们提议将我交给技术支持人员，该人员将向我收取500美元！

In Excel 2010, I have a worksheet containing Japanese text. There is no problem editing, or displaying this. When I grab the value of a cell containing Japanese and use Debug.Print to display it in the Immediate Window it appears as ???? This would be a familiar issue if I was dealing with a browser. I would just make sure everything was in UTF-8 encoding. I have Japanese installed on my English Windows and that's all working fine. In Excel I tried to set the default language to Japanese. I changed the editor font to Arial Unicode but so far I still get question marks. I contacted Microsoft. I was passed from one person to another, but they couldn't help. They offered to pass me to a Technical support person who would charge me 500 US dollars!

如何使用即时窗口在英文版的Excel中调试日语值?

How can I debug Japanese values in an English version of Excel using the Immediate Window?

推荐答案

VBA开发环境取决于Windows的系统区域设置"设置来告诉它要使用的字符集.我可以使用它

The VBA development environment depends on the Windows "system locale" setting to tell it what character set to use. I got it to work using

• Windows Vista(英语)
• Excel 2010(英语)

进入Windows控制面板的区域和语言选项"部分，并将系统区域设置设置为日语(日本)"

by going into the "Regional and Language Options" section of the Windows Control Panel and setting the system locale to "Japanese (Japan)"

系统重新启动后，我可以在VBA即时窗口中看到日语字符:

After my system rebooted I could see Japanese characters in the VBA Immediate Window:

这篇关于在Excel VBA的立即窗口中显示日语文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！