Category: VBA

Using a Treeview Control

This is a tutorial on the creation of a simple Treeview control on an Excel userform. For the purposes of this example, we'll be populating the Treeview control with worksheet names and the addresses of cells with formulas in them.

Read More »

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 »