Category Archives: VBA

No Thumbnail

Excel VBA, Remove Fill Pattern

Jump To: Remove Fill Pattern From Cell Remove Fill Pattern From Range Remove Fill Pattern From Column Remove Fill Pattern From Row Remove All Fill Pattern From Sheet – Remove Fill Pattern From Cell: The following line of code removes the fill pattern from cell

No Thumbnail

VB.Net Open Google Earth (Google Earth API)

This article explains how you can use VB.Net to open google earth. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the version might

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 VBA, Column Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Column: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

Excel VBA, Sheet Reference Speed

In the article Excel VBA Working With Sheets, I’ve explained that there are 3 different methods for referencing sheets. I have run tests on these methods to determine the fastest way of referencing sheets. Before explaining the tests, I have briefly explained the different methods of referencing sheets.

No Thumbnail

VBA Folder Dialog

The folder dialog is a dialog that prompts the user to select a directory path. Jump To: Example Button Name, ButtonName Change Title, Title Start Path, InitialFileName You can download the file and code for this file here. Please note that although the sample file is for

VBA intellisense Not Working

This article explains some of the common reasons why Intellisense might stop working  in the VBA Editor. – What is it? Intellisense is the drop down list that appears next to variables in the VBA editor: – Reason #1: If the following conditions are met intellisense

No Thumbnail

VBA Excel, Writing to a Text File

In this article I will explain how you can write data to a text file. Jump To: Example 1, Write One Line of Data to Text File Example 2, Write Multiple Lines of Data to Text File Example 3, Save File Dialog Example 4, Check