Japanese text in VBA

[jbrouse]

Greetings,

I have a workbook that was written in Japanese. Since all of the worksheet names are in Japanese, the VBA code will reference them as Japanese text. However, it appears that VBA does not support Japanese text, and all references to sheet names appear as jibberish.

I have a Japanese font on my computer, so I can read the sheet names and all text within the worksheet, but can someone please tell me how I can apply that font to my VBA code?

Any assistance would be appreciated!

 

[Von Pookie]

I have absolutely *no* idea if it will work or not as I have only used English Excel/fonts, but you can change the font used in the Visual Basic Editor.

Open VBE, go to Tools\Options\Editor Format tab and select a font from the dropdown list.

 

[jbrouse]

Worked like a charm...Thank you.