Font

Font Formatting: Commands specifically related to formatting fonts. Bold, italic, underline, font size, font color, font effects …

  • Excel VBA, Italic Font: Explains how to change the font style in a cell or range to italic. Also explains how to check whether the italic font style is currently used in a cell or range.
  • Excel VBA, Bold Font: Explains how to change the font style in a cell or range to bold. Also explains how to check whether the bold font style is currently used in a cell or range.
  • Underline font style: There are several different underline font styles applicable to cells and ranges.  Single, Double, Single Accounting, Double Accounting …
  • Excel VBA, Font Name: Explains how you can change the font (name) used in a cell or range. Also provides a sample code which gets the current font (name) used in a cell or range.
  • Font Color: Explains how you can change the font color of cells and ranges in Excel using VBA. Also provides an example on how you can get the current font color used in a cell.
  • Font Size: Explains how you can change the size of the font for a cell or range in Excel using VBA. Also provides an example on how you can retrieve the size of the font used in a cell or range.
  • Font Strikethrough: Explains how you can use VBA to add strikethrough to the font of cells and ranges. Also provides a sample code which checks if a cell has the strikethrough font or not.
  • Font Superscript: Explains how you can use VBA to change the font style in a cell or range to superscript. Also provides a sample code which checks if the font in a cell is superscript or not.
  • Font Subscript: Explains how you can use VBA to change the font style in a cell or range to subscript. Also provides a sample code which checks if the font in a cell is subscript or not.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s