Category: VBA

VBA vs VB.Net

Over the weekend I've spent a significant amount of time working in Visual Studio 2005 with VB.net. The more I work with it, the more I like the IDE, and some of the cool things that I can do in

Read More »

Modifying the Ribbon – Part 11

The history of posts on the Ribbon can be found at the Ribbon Example Table of Contents. For this installment, I thought I would focus on exploring the button control in depth, explaining what each piece of XML does when

Read More »

Modifying the Ribbon – Part 10

The history of posts on the Ribbon can be found at the Ribbon Example Table of Contents. The purpose of this post is to demonstrate how to use the Ribbon to interact with our application. Specifically, this example has an

Read More »

Modifying the Ribbon – Part 9

The history of posts on the Ribbon can be found at the Ribbon Example Table of Contents. In this article I'm going to demonstrate using an "edit box" to change the description of a button on the Ribbon. XML Markup

Read More »

Modifying the Ribbon – Part 8

The history of posts on the Ribbon can be found at the Ribbon Example Table of Contents. In this article I'm going to demonstrate a very simple menu created on the Ribbon.  This particular menu will only hold two buttons

Read More »

Ribbon Example Table of Contents

I've decided that it is time to start maintaining a Table of Contents for my Ribbon blog posts. It's just getting a little too hard to find them all. 🙂 I'll keep modifying this page, updating it as I add

Read More »

Using CustomUI Editor

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:

Read More »

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,

Read More »

Modifying the Ribbon – 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

Read More »