VBA - UserForm - Local Language

Contributor

Hello,

 

I created an Excel file that'll be used on different computers with different regional settings. Some of them are set to the local language some of then are on English. For the ones that are on English, the code written in VBA doesn't display text values in the local language so there are issues with special characters. Please note that this is not an editor issue. Hardcoded text values are not displayed correctly in Excel. Is it possible to force VBA to treat the code in a specific language?

 

From what I understand it's possible fix the issue by changing non-unicode language to the local language but it's not possible for us that change that setting on our computers.

 

Thanks.

0 Replies