Author: Ken Puls

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 »

A Comment on RibbonX Callbacks

I found this kind of interesting, but somewhat strange... A couple of nights ago I spent a significant amount of wasted time trying to get a callback to work in Visual Studio 2005. The problem was that I was trying

Read More »

Installing Visual Studio 2005

Well, I've finally done it. I've just finished installing Visual Studio 2005 Professional, complete with patches, the MSDN Library files and VSTO 2005 SE Beta. 🙂 I figured that I might as well just bite the bullet on it, as

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 »