Unicode, possible or impossible?   

I was just trying to simply display a MessageBox in Japanese in
Microsoft Outlook 2007 Visual Basic Editor.
msgbox "$B$3$s$K$A$O(B" (Japanese phrase for Hello)
but it became
msgbox "??????"
as I type.

So, typing in Unicode (Asian chatracters) is impossible in VBA? I
don't want a solution, I just want to know if it is possible or not in
order not to spend my time trying to do something impossible.

Thank you.

date: Wed, 2 Jul 2008 03:39:55 -0700 (PDT)   author:   RealCat

RE: Unicode, possible or impossible?   

Maybe a UserFrom rather tahn a MsgBox.....See Ogilvy's code in:

http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/ea2b895a7b6cd264/8c22806f245b8b72?lnk=gst&q=userform++unicode#8c22806f245b8b72
-- 
Gary''s Student - gsnu200794


"RealCat" wrote:

> I was just trying to simply display a MessageBox in Japanese in
> Microsoft Outlook 2007 Visual Basic Editor.
> msgbox "こんにちは" (Japanese phrase for Hello)
> but it became
> msgbox "??????"
> as I type.
> 
> So, typing in Unicode (Asian chatracters) is impossible in VBA? I
> don't want a solution, I just want to know if it is possible or not in
> order not to spend my time trying to do something impossible.
> 
> Thank you.
>

date: Fri, 4 Jul 2008 04:50:01 -0700   author:   Gary''s Student

RE: Unicode, possible or impossible?   

Ο χρήστης "RealCat" έγγραψε:

> I was just trying to simply display a MessageBox in Japanese in
> Microsoft Outlook 2007 Visual Basic Editor.
> msgbox "こんにちは" (Japanese phrase for Hello)
> but it became
> msgbox "??????"
> as I type.
> 
> So, typing in Unicode (Asian chatracters) is impossible in VBA? I
> don't want a solution, I just want to know if it is possible or not in
> order not to spend my time trying to do something impossible.
> 
> Thank you.
>

date: Fri, 4 Jul 2008 22:49:01 -0700   author:   Help from Cyprus Help from

RE: Unicode, possible or impossible?   

Ο χρήστης "RealCat" έγγραψε:

> I was just trying to simply display a MessageBox in Japanese in
> Microsoft Outlook 2007 Visual Basic Editor.
> msgbox "こんにちは" (Japanese phrase for Hello)
> but it became
> msgbox "??????"
> as I type.
> 
> So, typing in Unicode (Asian chatracters) is impossible in VBA? I
> don't want a solution, I just want to know if it is possible or not in
> order not to spend my time trying to do something impossible.
> 
> Thank you.
>

date: Fri, 4 Jul 2008 22:50:00 -0700   author:   Help from Cyprus

RE: Unicode, possible or impossible?   

Had a similar problem with greek.

The problem occurs because most computers are never set up properly and they 
think they reside in the US. In the regional setting of the user they need to 
have selected the asian fonts in the Advanced language options (or greek in 
my case) however I have not sussed out how to do directly it from the vba 
coding side. If you find out let me know too.

date: Fri, 4 Jul 2008 22:53:00 -0700   author:   Help from Cyprus