Finding actual font used for a TextRange

[josh.projects]

Hello all,

According to the VBA documentation, the TextRange.Font object stores
several different font names (Font.Name, Font.NameAscii,
Font.NameFarEast, Font.NameComplexScript, Font.NameOther). Is there a
simple way to find out which one of those fonts is actually used to
display a given chunk of text?

I suppose it might be possible by checking the Unicode character range
manually (for example, if the text contains Chinese/Japanese/Korean
characters, the font specified by NameFarEast is used), but I'm not
sure when NameComplexScript and NameOther would be used.

Thanks in advance.

 

[josh.projects]

Hmm... after some more experimentation, it seems that the actual font
used is in TextRange.Font.Name. Can anyone confirm?

 

[John Wilson]

That should give you the name of the font
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

 

[josh.projects]

Got it, thanks very much.

That should give you the name of the font
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.ukhttp://www.technologytrish.co.uk
email john AT technologytrish.co.uk