Displaying Quick Numerical info
Excel has a very handy little feature that is included on the Excel status bar. It shows a quick snapshot of information that may be helpful if you are working with numbers. To display its use, enter a few numbers
Excel has a very handy little feature that is included on the Excel status bar. It shows a quick snapshot of information that may be helpful if you are working with numbers. To display its use, enter a few numbers
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
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
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
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
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.
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
Introduction This is one of my favourite functions to use in my projects. While VB's standard GetOpenFilename works great if you are in the correct directory, this saves my users time as I can tell it exactly where I want
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.