VBA Cannot read ZH_CN (Chinese) Language MAC OS

Question

Hi, I'm encountering VBA that cannot read/see/write Chinese language,

It will be showing Chinese language when I change system language into Chinese, If there's any way without changing system language into Chinese instead? Looking for the solution here

Answer 1

Hi @RudRud,

As per my research, the marked answer in this thread may help in this case: Using multiple language (english, chinese, japanese) in VBA. Use bytearrays instead of strings to declare the strings. That way, the VBA IDE can store the data independent of locale settings.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.