Japanese text in VBA

jbrouse

Active Member
Joined
Apr 28, 2005
Messages
329
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!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
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.
 

Forum statistics

Threads
1,136,878
Messages
5,678,301
Members
419,753
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top