Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks
Dan |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks. And what about Text+Symbol in the same Label caption. Is there
such possibility Dan |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom,
For Label on Sheet correctly is --------------------------- Private Sub Worksheet_Activate() Label1.Caption = "Zmiennosc" & ChrW(928) End Sub --------------------------- ? Regards Dan |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom,
For Label on Sheet correctly is --------------------------- Private Sub Worksheet_Activate() Label1.Caption = "Text" & ChrW(928) End Sub --------------------------- ? Regards Dan |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
And how to identify chrW number for needed symbol?
|
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing values of x-axis to include greek letters | Charts and Charting in Excel | |||
label caption | Excel Discussion (Misc queries) | |||
Is it a comment ? or a label ? or a caption ?.... | Excel Discussion (Misc queries) | |||
Label - Caption not changing | Excel Programming | |||
label caption | Excel Programming |