If you are working with RibbonX code in Microsoft Office, you no doubt use the CustomUI editor from OpenXML Developer. The tool has is an essential one for working with RibbonX and Office as it offers us the following advantages:
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
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
