VBA Cannot read ZH_CN (Chinese) Language MAC OS

RudRud 0 Reputation points

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

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 17,581 Reputation points Microsoft Vendor

    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.