0

I can't set Sheet.Name property in Japanese. Event file name also displays in maybe Chinese? All display well in Excel.

How can I set up the VBA editor to work with Japanese?

I changed region to Japanese.

enter image description here

Community
  • 1
  • 1
dellos
  • 327
  • 5
  • 15
  • this might help: https://stackoverflow.com/questions/34745025/how-to-enable-unicode-in-excel-2016-vba-editor – stifin Mar 31 '22 at 03:31
  • @stifin, none of that is working. I think Editor itself not recognition Japanese string – dellos Mar 31 '22 at 03:35
  • you mean if you set your entire system to Japanese, it doesn't work? I would expect that that _should_ work, otherwise it implies that Japanese people can't use VBA without using English Windows – stifin Mar 31 '22 at 03:38
  • yeah, don't know where it was going wrong. Window display, Administration, Region, time all I changed to 日本. – dellos Mar 31 '22 at 03:44
  • followed by restart -- as I think Windows won't switch code pages without the restart – stifin Mar 31 '22 at 05:39
  • I was restarted. VBA menu display Japanese but other places in VBA editor was not. – dellos Mar 31 '22 at 06:02
  • it's been a long time since I worked with dbcs, but I remember that there were places where you still would see "???". However, if you displayed wide characters in a font that supports those characters, they could still display in the UI... but this is just my memory going back over 10 years ago – stifin Mar 31 '22 at 06:32
  • Please [edit] your question to provide a [mcve]. Generally, share _text_ rather than _picture of text_. – JosefZ Mar 31 '22 at 07:55

1 Answers1

1

Finally, I got to the right point.

this post is in Japanese but by picture so not hard to see that in Admitration we must uncheck [Header: World Wide language support ... use Unicode UTF-8]

maybe as @stifin mentioned, it is about wide character. Answer

dellos
  • 327
  • 5
  • 15