Home >Common Problem >How to deal with Chinese garbled characters in VBA editor

How to deal with Chinese garbled characters in VBA editor

coldplay.xixi
coldplay.xixiOriginal
2020-08-19 13:41:3926647browse

Solution to Chinese garbled characters in the VBA editor: 1. Click [Tools → Options → Editor Format] to open the window and correct the font options to Chinese fonts; 2. Use the Traditional and Simplified conversion in Excel review , convert the code back to Simplified Chinese.

How to deal with Chinese garbled characters in VBA editor

Solution to Chinese garbled characters in the VBA editor:

1. Tools → Options → Editor Format Window , correct the font option to Chinese font;

2. Follow the steps below to change the language of non-Unicode programs:

Control Panel=>Clock, Language and Region=>Region= >Manage=>Language for non-Unicode programs=>Change the system locale to Chinese (Simplified, China)=>Restart the computer.

3. If the code is messed up. Especially for traditional Chinese, you can use the traditional-simplified conversion in Excel review to convert the code back to simplified

4. If the Chinese code is clearly copied, copy it to another module, especially to the remote desktop On the computer, the Chinese code will become garbled

This is proven to be feasible based on my continuous experience: before copying and pasting the VBA code, set the input method to Chinese state, and then copy and paste it. It will be normal.

The above is the detailed content of How to deal with Chinese garbled characters in VBA editor. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn