Tag Archives: Sample

No Thumbnail

Excel VBA, Fill Pattern

Various different patterns can be applied to cells in Excel. These patterns can be applied manually using the Format Cell dialog: This article will explain how you can apply different patterns to cells using VBA for Excel. Jump To: Basics Example 1, Set Pattern Example

No Thumbnail

Excel Functions and Formulas, INDIRECT()

The INDIRECT() function returns a reference specified by a text string. For example the formula below: =INDIRECT(“A1″) returns the value in cell “A1”. You can download the workbook related to this article here. Jump To: Syntax Example 1, Get Value From List, Based on Row Index Example

No Thumbnail

Excel VBA Set Underline (Sample Code + Download)

In this article I’ve provided an example on how you could use VBA to set underlines for cells and ranges. There are 4 different underline style the user can select from: Single Double Single Accounting Double Accounting For more information about the different underline types and their associate VBA code please

No Thumbnail

Excel VBA, Border Style and Thickness

In this article I will explain how you can modify border thickness and style using VBA for Excel. For more information about creating borders please see Excel VBA, Create Border. In that article I’ve explained how you can create a border for the different sections of a

No Thumbnail

Excel VBA, Underline Font Style

This article explains the different types of underlines possible to apply to cells and ranges. It also provides the associated VBA code for adding the underline. For examples using these codes please see: Excel VBA Set Underline (Sample Code + Download) Excel VBA Get Underline

No Thumbnail

Excel VBA, Set Vertical Alignment (Sample Code)

In this article I will provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical  alignment will be applied to the cell below the drop down list. You can download the file and code related to this article here. Upon

No Thumbnail

Excel, DATEVALUE() Function

The DATEVALUE() function receives as input a text string representing a date. The function returns as output the date value corresponding to the input date text string. Jump To: Syntax Basic Example Why? More Examples – Syntax: =DATEVALUE(Date_Text) Date_Text: A text string representing a date. – Basic Example:

No Thumbnail

Excel VBA, Color Code

This article provides a sample on using the color code in VBA for Excel. In this example the user inputs a color code in cell B1. The fill color in cell A1 is changed to the color defined by the color code in cell B1.

No Thumbnail

Excel VBA, Font Size

In this article I will explain how you can change the size of the font for a cell or range in Excel using VBA. I’ve also provided an example on how you can retrieve the size of the font used in a cell or range.