How to find direct formatting using vba code (1)

**bwang** · 2001-09-19 18:36

Hi, guys:

How to find direct font formatting using vba code? and change the font to default one, but keep underline,
bold,italic untouched?

Thanks

**gwhitfield** · 2001-09-19 19:10

Word, Excel, Powerpoint, other?

Selection.Font.Name = "Arial"

works in Word and Excel- but if you want to apply without using a selection (or, for instance, applying a font to just a part of a single cell in Excel), you may need to know more about the way Word/Excel/PPT works

**rory** · 2001-09-20 11:04

Hi,
Do you mean something like:
Selection.Font.Name = Application.Standardfont?
(There's not a lot of point checking to see if it is already the default font)
Hope that helps.

Thread: How to find direct formatting using vba code (1)

Thread Tools