Visual basic Userform caption
 

Hi everyone,

my problem is the next one: I have a form and in this form, I try to
put Mandarin, who is in a Cell on my Excel 2000, in the caption but
it gives me "?????" at the place.

Any help would be appreciated.

Thanks !

Visual basic Userform caption
 

Me.Caption = Worksheets(1).Range("A1").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
om...
Hi everyone,

my problem is the next one: I have a form and in this form, I try to
put Mandarin, who is in a Cell on my Excel 2000, in the caption but
it gives me "?????" at the place.

Any help would be appreciated.

Thanks !

Visual basic Userform caption
 

You can put some code in the UserForm's Initialize event. Here, it will use
the value in A1 on Sheet1:

Private Sub UserForm_Initialize()
Me.Caption = ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e
End Sub

hth,

Doug Glancy

wrote in message
om...
Hi everyone,

my problem is the next one: I have a form and in this form, I try to
put Mandarin, who is in a Cell on my Excel 2000, in the caption but
it gives me "?????" at the place.

Any help would be appreciated.

Thanks !

Visual basic Userform caption
 

ok guys, thanks ! but the way you are telling me to do this was the
first thing I have tried, I'm not a newbie to Excel ;-), it's not
simple as it seems.
If you want, you can try by yourself, try to put a special character
like mandarin language in the caption of the form and it will give you
"???", for sure.

Thanks anyway.

Max

Visual basic Userform caption
 

One more thing,

if I put mandarin in a textbox or a label, it's ok, I can see it and
it doesn't give me "???".
Would it be possible to change the nature of the titlebar, the
caption, to act like a textbox or a label ?

Visual basic Userform caption
 

Max,

I see what you are saying now. Unfortunately I don't have an answer. I
guess I'd check any language features that could be installed in Office, but
I don't really think that's the answer either.

Doug Glancy
wrote in message
om...
One more thing,

if I put mandarin in a textbox or a label, it's ok, I can see it and
it doesn't give me "???".
Would it be possible to change the nature of the titlebar, the
caption, to act like a textbox or a label ?

Visual basic Userform caption
 

go to the windows desktop and right click on a blank area. select
properties. then go to the appearance tab. in the picture, click on the
caption area and you have a choice to change the font. Try making it a
unicode font. Perhaps that will work.

--
Regards,
Tom Ogilvy

wrote in message
om...
One more thing,

if I put mandarin in a textbox or a label, it's ok, I can see it and
it doesn't give me "???".
Would it be possible to change the nature of the titlebar, the
caption, to act like a textbox or a label ?

Visual basic Userform caption
 

In VBA, it is possible to take off the title bar, maybe it will be easier like this.

Max

"Tom Ogilvy" wrote in message ...
go to the windows desktop and right click on a blank area. select
properties. then go to the appearance tab. in the picture, click on the
caption area and you have a choice to change the font. Try making it a
unicode font. Perhaps that will work.

--
Regards,
Tom Ogilvy

wrote in message
om...
One more thing,

if I put mandarin in a textbox or a label, it's ok, I can see it and
it doesn't give me "???".
Would it be possible to change the nature of the titlebar, the
caption, to act like a textbox or a label ?

Visual basic Userform caption
 

Doug,

it's certainly possible to put a patch in Office or something like
that but the thing is that the application that I'm working on will be
world wide so any person who will open the application, will not have
the patch because it will be their own Excel.

Max

"Doug Glancy" wrote in message ...
Max,

I see what you are saying now. Unfortunately I don't have an answer. I
guess I'd check any language features that could be installed in Office, but
I don't really think that's the answer either.

Doug Glancy
wrote in message
om...
One more thing,

if I put mandarin in a textbox or a label, it's ok, I can see it and
it doesn't give me "???".
Would it be possible to change the nature of the titlebar, the
caption, to act like a textbox or a label ?

Visual basic Userform caption
 

I've got the answer

http://www.vb-fun.de/cgi-bin/loadfra.../tip0212.shtml

Thanks

Max