Category Archives: Sample Codes and Downloads

No Thumbnail

Excel COUNT() Function

In this article I will explain the count function. The COUNT() function returns the number of cells in a range which have numeric values in them. You can download the workbook for this article here. Jump To: Syntex Example 1, Get Row Count Example 2,

No Thumbnail

Excel VBA, Bold Font

In this article I will explain how you can use VBA to change the bold font property of cells and ranges. I have also provided an example on how to check if a cells has the bold font property on or off. Jump To: Basics

No Thumbnail

Excel VBA, Color Dialog xlDialogEditColor

The xlDialogEditColor is a dialog used to get a color code from the user. Color codes are used to specify colors in VBA for Excel. For more information about working with colors please see Excel VBA Colors. Jump To: Syntax Examples Example 2, Set Fill Color You can

No Thumbnail

Excel VBA, Orientation (Alignment)

In this article I will explain how you can change the orientation of the content in cells. I have also provided several sample codes. Jump To: Example 1, Basics Example 2, Set Orientation Example 3, Get Orientation You can download the file and code related

No Thumbnail

Excel VBA, Set Horizontal Alignment, (Sample Code)

In this article I will provide an example on how to set the horizontal alignment of cells using VBA. The user selects the horizontal alignment from a set of drop down lists. The selected horizontal alignment will be applied to the cell adjacent to the drop down list. You

No Thumbnail

Excel VBA, Get Color Code

This article provides a sample for getting the desired color code. The user selects a fill color for the cell A1. After pressing the Get Code button the color code used will be printed in cell B1. It can be seen from the figures below that

No Thumbnail

Excel VBA, RGB

As previously mentioned in the article Excel VBA, Color Code when working with colors in Excel you must know their color code. Though sometimes you may want set the color by using the RGB color model. This can be achieved using the RGB() function. For more information

No Thumbnail

Excel VBA, Getting the Color Code Using the Macro Recorder

In a previous article I’ve provided a sample code for getting the color code based on the fill color of a cell, Excel VBA, Get Color Code. In that example the user changes the fill color of the cell A1. After pressing the Get Code button the