VBA and VB.Net Tutorials, Education and Programming Services

Tag Archives: Font Color

Excel VBA Formatting Cells and Ranges Using the Macro Recorder

By formatting cells and ranges you can give your worksheets a better look. Formatting applies to the following: The number format: Numeric, Date, Scientific … Text Alignment: Horizontal, Vertical, Orientation … Text Control: Wrap Text, Shrink to fit, Merge Cells … Text Direction Font Type:

VBA, Excel Font Formatting

This article explains the different font formatting options applicable to cells and ranges using VBA. Each section provides a link to a more detailed explanation with VBA code samples. When you right click a cell and select Format Cells a dialog will open: The Font tab has all the possible formatting