how to include foreign characters within a VB code module

[Guest]

I am writing an application within Excel which allows to user to perform certain operations. Then a status is displayed in a popup after each operation, for example "Your operation is successful". Now I want to have this message in different languages so that the message would appear in Chinese to a Chinese user, for example. The problem is that when I copy a pasted Chinese characters into the VB code, all I see are lots of question marks. Does anyone know how I can configure this code module to use UTF-8 encoding so that I can enter foreign characters

Thanks in advance for your help
nhilam

 

[Bob Flanagan]

Nhilam, why not store the values on a worksheet and then copy the correct
language message to your message box?

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

I am writing an application within Excel which allows to user to perform

certain operations. Then a status is displayed in a popup after each
operation, for example "Your operation is successful". Now I want to have
this message in different languages so that the message would appear in
Chinese to a Chinese user, for example. The problem is that when I copy a
pasted Chinese characters into the VB code, all I see are lots of question
marks. Does anyone know how I can configure this code module to use UTF-8
encoding so that I can enter foreign characters?

 

[Guest]

Thanks, Bob. That would certainly work. I was trying to see if there's a way to do it in the code module which would involve less code changes
nhilam