Modifying the Ribbon – Part 6
As mentioned in Part 5 of this series, this post will display how to change the value of a Ribbon control from a VBA procedure. For this example, we will continue to work with the case presented in Part 5,
As mentioned in Part 5 of this series, this post will display how to change the value of a Ribbon control from a VBA procedure. For this example, we will continue to work with the case presented in Part 5,
Previous posts on this subject: -Part 1 -Part 2 -Part 3 -Part 4 Creating a CheckBox Until now, all the posts have focussed on creating buttons in a variety of styles, shapes and sizes. Today, we'll take a look at
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
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
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
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,
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
