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
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
XLG Favourites Add-in Instructions This article contains instructions for the installation and usage of the XLG Favourites Add-in. To download this add-in, please visit the XLG Favourites Add-in page. Installation: Download and extract the package to your local PC or
XLG Favourites This add-in was created to increase the functionality of Excel and address some shortcomings in the "Most Recently Used Files" listing. While we can increase the list to hold 9 items, I frequently use more than that many
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
UseTemplate Add-in Instructions This article contains instructions for the installation and usage of the UseTemplate Add-in. To download this add-in, please visit the UseTemplate Add-in page. Installation Download and extract the package to your local PC or the network drive
Templates Addin This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six
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
I can't claim the original idea for this article. The concept actually comes from Professional Excel Development, but I developed the code, such as it is here, on my own. The reason for this was because I couldn't find it
Introduction: This article shows the method I use to maintain versions and builds in my applications and add-ins, which is to add properties to the ThisWorkbook module. These properties store their values in custom document properties, accessed from File|Properties|Custom, as
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
