Visual basic Userform caption

[nik001_]

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 !

 

[Bob Phillips]

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)

 

[Doug Glancy]

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").Value
End Sub

hth,

Doug Glancy

 

[nik001_]

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

 

[nik001_]

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 ?

 

[Doug Glancy]

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

 

[Tom Ogilvy]

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.

 

[nik001_]

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

Max

 

[nik001_]

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

 

[nik001_]

I've got the answer

http://www.vb-fun.de/cgi-bin/loadframe.pl?ID=vb/tipps/tip0212.shtml

Thanks

Max