Read Japanese Character's from Cell

[Halley yenn]

Hey Folks,

I have a excel with cell values in both English and Japanese (for ex: Name/名前). I want to declare this in my macro code as below :

If (WB.Range("A" & i).Value) = "Name/名前" And WB.Range("B" & i).Value) <> "" Then
validrecord = "true"
But it is failing to read the Japanese characters and showing like("Name/??") .

Any help is much appreciated.

Regards,
Halley

 

[Marc L]

Hi,​

​

you should use the ChrW statement to enter any Japanese character under VBA.​

​

Or you can check just the beginning of the cell for the occidental characters with the Like operator : If (WB.Cells(i, 1).Text like "Name/*" …​

 

[Halley yenn]

Hi,​

​

you should use the ChrW statement to enter any Japanese character under VBA.​

​

Or you can check just the beginning of the cell for the occidental characters with the Like operator : If (WB.Cells(i, 1).Text like "Name/*" …​

Thanks Marc.