Excel VBA - Japanese font

Hi and thanks for reading.

I have an Excel spreadsheet that successfully displays Japanese characters. But when I try to access the text or value property of a cell with these characters in VBA, all I get is question marks returned in place of the actual characters. (e.g., if I type "? cells(1,1).text" in the immediate pane, I get ????????????? returned.)

How can I access the actual Japanese characters in VBA?

For what it's worth, languages such as French, Spanish, Dutch, etc. are handled just fine.

Thanks!
OneSource

Its probably to do with Unicode (two bytes per character instead of one).

Try looking at these functions:
AscW
ChrW

and a search for unicode conversion/help.


Vince

your response helped! :thumb:

OneSource