Category: VBA

Modifying the Ribbon – Part 4

Previous posts on this subject: -Part 1 -Part 2 -Part 3 Using Your Own Picture on a Button Well... maybe not your own picture... unless you're feeling vain today. 😉 I really meant using an image of your choice. This

Modifying the Ribbon – Part 3

Here's the previous parts to this: -Part 1 -Part 2 Using Excel's Images on Custom Ribbon Controls In Part 2, we built the following custom group on a custom tab: This time, we'll replace all the happy face images with

Modifying the Ribbon – Part 1 of many

I've decided to start playing around with the Ribbon, and figured that I might as well document my journey through this new piece of Excel. I'm going to start fairly slow with it, and add more as I experiment with

Creating Your Own Constants For Functions

One of the items that is very useful in code is the use of constants. These items are simply text masks that translate to numbers, making it easier for us to remember how to interact with the code. For example,

Using Help in Your Applications

Introduction: One of the biggest parts lacking in user constructed solutions is documentation in the form of help files. As coders, we usually find it easier to build the application than explain to someone how to use it properly. After

Printing Access Reports To A PDF File

This article contains code examples to print a Microsoft Access report to a PDF file. This code examples is built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create

Function To Check If File Or Directory (Folder) Exists

Introduction: When creating routines, it is commonly helpful to check if a file or directory (folder) exists before attempting to perform some action. Searching the internet will yield several examples of doing either, but this is a routine that I

Fill MultiColumn Listbox With Worksheet Range

Introduction: This article gives two methods to fill a multi column listbox on a userform with data from an Excel worksheet. Pulling the worksheet range directly into a listbox Pulling the data into an array first, then placing the array

Creating an Access Database (on the fly) Using VBA and SQL

I recently had reason to create a database on the fly if one did not exist. Since it took me some trial, error and searching (and then more trial and error,) I decided to share the method to do this.

Controlling When Application Properties Are Toggled and Controlling Events

This article actually covers two topics. The first is on controlling when application properties are toggled, and the second shows how to adapt that methodology into a superior method to manage events and prevent recursive calls. The first example set