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
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
Part 1 of this series can be found here. In this post, I'm going to show a few more examples of customizing the ribbon using buttons. (We'll get to other types of controls later.) All of these are variations of
Now this is kind of cool... In Excel 2003, when you opened the brackets on a formula, it would launch a little help feature as shown below: In Excel 2007, they go one step further. As soon as you hit
Over the past year and a bit, I've begun playing with Virtualization on my PC. The reason was mainly because I got very tired of having to rebuild my OS when I inevitably got it so cluttered with garbage that
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,
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
