Value VBA read from file different as declared value

Question

My file write VBA code for read sheet name Thailand language.

A module VBA, I declare a variable SHEET_NAME_1 = " การคำนวณราคา", it corresponding sheet name " การคำนวณราคา". But when run VBA code, SHEET_NAME_1 gets value is " ｡ﾒﾃ､ﾓｹﾇｳﾃﾒ､ﾒ". I tried change format font to Thai

But it still receive value look like Japanese value.

I tried change region to Thailand too

Because value receive from code different as sheet name so error happened

How can resolve it?

Answer 1

I put it in the answer but I am not sure if this is going to help you. In excel, click on files, below you will find options. Click Language. Can it be your settings here are not for Tailand?