A little background A while ago, I blogged about the Excel 2007 Icon Gallery, which is available from Microsoft right here. It's a useful tool when you're trying to identify the imageMso that you're after, no question... but there's a
Now this is straight out of the "How cool is that?" file. 🙂 Last week, I got an email asking a question about adapting the Print Multiple Worksheets to a PDF article that I have on my site so that
Hello folks, Here's another resource that I'm going to add to my RibbonX table of contents... it's the list of Office 2007 Control ID's. This is a package of 24 Excel spreadsheets that list all of the Ribbon control names,
The history of posts on the Ribbon can be found at the Ribbon Example Table of Contents. This blogpost deals with a slightly more dynamic use of RibbonX than we've dealt with in the past here. Specifically, this post illustrates
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
There are a great many errors that we can run into when programming, and just on of those is a Compile Error, specifically "User-Defined Type Not Defined". This error could mean one of a few different things, which may not
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
A problem than can occur when working with PDFCreator via code is that sometimes the code releases PDFCreator too early, and it isn't properly closed. What is happening? At the end of the PDFCreator routines on this site, we release
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.
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
