Author: Ken Puls

Forms Controls

I got an email the other day from a friend wondering if I had anything to explain how to use Form controls. I don't use them a lot, but they can be quite handy, and ironically I'd just finished using

Read More »

Office 2007 Icon Gallery

No more fooling around trying to figure out what the idMso is for the built in Excel commands when you're trying to customize the Ribbon. There is a great little download available from Microsoft to add a group of galleries

Read More »

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 »