Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

Hi,

Is there possibility to use in a Label caption the greek letter? And
more generally in captions of the ActiveX controls?

Regards

Dan

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 718
Default Greek letters in Label caption

PropertiesFont , enter: Symbol

HTH
--
AP

a écrit dans le message de news:
...
Hi,

Is there possibility to use in a Label caption the greek letter? And
more generally in captions of the ActiveX controls?

Regards

Dan



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

Thanks

Dan

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

Thanks. And what about Text+Symbol in the same Label caption. Is there
such possibility

Dan

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

Thanks Tom,

For Label on Sheet correctly is

---------------------------
Private Sub Worksheet_Activate()

Label1.Caption = "Zmiennosc" & ChrW(928)

End Sub
--------------------------- ?


Regards

Dan



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

Thanks Tom,

For Label on Sheet correctly is

---------------------------
Private Sub Worksheet_Activate()

Label1.Caption = "Text" & ChrW(928)

End Sub
--------------------------- ?


Regards

Dan

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Greek letters in Label caption

And how to identify chrW number for needed symbol?

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Greek letters in Label caption

Daniel,
Use the Character map, charmap.exe.
Depending how your system is set up, it may be on the Start menu, under
AccessoriesSystem Tools.
Set the font you are using, locate the required symbol, then look at the
bottom right hand corner for something like "U+03A0: Greek Capital Letter
Pi". That the number in Hex that you need for ChrW().

NickHK

wrote in message
oups.com...
And how to identify chrW number for needed symbol?



  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Greek letters in Label caption

You can only assign one font to the controls. So if you only want greek
symbols, assign the Symbol font. If you want mixed english and greek, then
.. If you have Windows XP/2000/NT4, and have a unicode font on your machine,
Such as Arial Unicode MS, you can assign that font to the label or control
and then use the initalize event of the userform

Private Sub Userform_Initialize()
Label1.Caption = chrw(65) & chrw(928)
End Sub

for example which puts in a Capital A and the greek sympol uppercase PI.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Hi,

Is there possibility to use in a Label caption the greek letter? And
more generally in captions of the ActiveX controls?

Regards

Dan



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing values of x-axis to include greek letters Al Charts and Charting in Excel 5 November 8th 07 12:27 AM
label caption gramps Excel Discussion (Misc queries) 0 November 1st 07 03:56 PM
Is it a comment ? or a label ? or a caption ?.... mars Excel Discussion (Misc queries) 2 May 24th 07 11:15 PM
Label - Caption not changing Brian Hribek[_2_] Excel Programming 0 October 11th 04 10:02 PM
label caption Rod Taylor Excel Programming 2 July 31st 03 03:25 AM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"