Tag Archives: Sample Code

No Thumbnail

Excel VBA, Italic Font

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

No Thumbnail

Create Invoice/Bill Using VLOOKUP (Step by Step Tutorial)

In this article I will provide a step by step tutorial to explain how you can create an Invoice using VLOOKUP. I’ve explained the basics of using VLOOKUP in VLOOKUP, Excel Functions so I’m assuming you are familiar with the function. You can also download the complete Invoice file here. Jump To:

No Thumbnail

Excel VBA, Get Vertical Alignment (Sample Code)

In this article I will provide an example on how to find cells with a specific vertical alignment. You can download the code and file related to this article here. The user selects the desired vertical alignment to find from a drop down list: After pressing the run button

No Thumbnail

VBA UserForm Drop Down Lists

In this article I will explain the userform drop down list. This drop down list is actually called a combo box. It is used in user forms. Jump To: Creating Adding Items Inserting Items Modifying Items Removing Items Get Selected Index Get Selected Item Item

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, 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