Category Archives: Excel

No Thumbnail

Excel VBA, XlRgbColor

The enum XlRgbColor contains a list of color codes. Although this list is limited but often it is enough to get the job done. If you require more specific colors please see Excel VBA, Color Code. In the example below the color code associated with some of

No Thumbnail

Excel Custom Formatting, 0, # and ? characters

In this article I will explain the characters “0”, “#” and “?” used in custom formats. – “0” Character: The “0” is a placeholder for digits. On the left hand side of the decimal: If  there aren’t enough digits to fill the placeholders, zeros will be added

No Thumbnail

Excel VBA Remove Range Fill Color

The following line of code removes the fill color of the range A1:B2: Range(“A1:B2”).Interior.Color = xlNone The following line of code does the same: Range(Cells(1, 1), Cells(2, 2)).Interior.Color = xlNone Before: After: See also: Excel VBA, Cell Fill Color Excel VBA, Formatting Cells and Ranges using

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 Functions and Formulas, TEXT()

The TEXT() function converts a number value to a text string, with the format specified Jump To: Syntax Example 1, Converting Numeric Value to a Text String Using Currency Formatting Example 2, Adding Converted Value to a Text String Example 3, Converting Numeric Value to

No Thumbnail

Excel Drop Down Lists

Generally speaking there are 3 types of drop down lists in Excel: Form Control ActiveX Data Validation. In this article I will brieftly explain each one and provide links to more detailed explanation of each. – Form Control (Combo Box): These drop down lists which are

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 Strings: Common Errors When Using Strings

In this article I will explain some of the most common errors people encounter while working with strings. For more information regarding string commands please visit VBA Excel String Processing and Manipulation. You can download the codes and files related to this article here. Jump To: