Tag Archives: VBA

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

VBA, Create New Access Database From Excel

In this article I will explain how you can create a new (blank) access database from Excel. There are 2 methods for getting this done: Late Binding Early Binding In early binding we add a reference to the Access Object Library. The benefit of using early binding

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 Open File Dialog

There may be times when you need to ask the user to select a file to open. This can be done using the open file dialog. Keep in mind that the open file dialogs doesn’t actually open anything. It returns the path of the file

No Thumbnail

VBA Editor, Indent and Outdent Blocks of Code

In this article I will explain how you can indent and Outdent blocks of code. – Step 1, Select the Text to Indent: The first step would be to select the block of text you would like to indent: – Step 2, Press TAB: By

No Thumbnail

Word VBA, Read All Lines

In this article I will explain how you can use VBA to read every line in a word document and store the values in a string array/collection. – Method 1: In this method the VBA code will select the entire document. After selecting the entire document the

No Thumbnail

Excel VBA Range Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient colors. I’m assuming readers are familiar with the concepts explained in that article before reading this article. Jump To: Gradient Color, Range Modify Existing Gradients Color for Range – Gradient Color, Range: