Category Archives: Excel

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

Excel Hyperlinks To Cell or Range

In this article I will explain how you can create hyperlinks in Excel that will take the user to another location in the workbook. For example lets say we have the following data in sheet1: When the user selects each item, we want the user to

Excel VBA, Export Worksheet to Blank Access Table

In this article I will explain how you can export values from an excel worksheet to a new blank Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we

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 Custom Formatting Adding Characters and Text

When working with custom formats in Excel there may be times you want to add a specific character or text string before or after the cell value. I will be explain this using examples in this article. – Literal Characters: There are certain characters that will

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, User Forms, Labels and TextBoxes

This article will discuss the main functionalists of the label and textbox objects used in the user form. Labels are basically used for text that the user can’t modify while textboxes are used to get input from the user. You can download the codes and files related to this