type greek character

  • Thread starter Thread starter Young-Hwan Choi
  • Start date Start date
Y

Young-Hwan Choi

how to write a code to type a Greek character (alpha, beta, etc.) in a
chartitle?

thanks in advance
 
The appearance of fonts is defined by the font name. You can make the font
name Symbol to get greek characters.
 
Young-Hwan,

Start | Run | Charmap
Ensure font is Arial.
Scroll down the list until you find Greek Small Leter Alpha, Beta, Gamma,
etc.
Copy these characters to clipboard then paste them into your Chart Title.

Rob
 
Use the Characters property of the ChartTitle object to access
individual characters within the text of the title, and change
the font of the desired characters to "Symbol".

Dim ChtTtl As ChartTitle
Set ChtTtl = ActiveSheet.ChartObjects(1).Chart.ChartTitle
ChtTtl.Characters(Start:=4, Length:=1).Font.Name = "Symbol"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top