Most of us, when we start dabbling with Excel macros, probably take the following steps: Record code Begin to make minor edits to the code Eventually learn about loops and start using them everywhere Learn that loops are "expensive" and
So the other day I got a complaint from one of my users:Â "I really wish you'd fix the Excel tabbing issue in this file." Now I've sent a considerable amount of time training my users to enter data in
This is a pretty cool new feature in Excel 2007 that I think will pay some dividends to people. The main intention is to ensure that users working in 2007 files are notified when they'll lose functionality by saving back
This came as a bit of a surprise to me, but you can no longer open/save a file in the old Lotus wks format in Excel 2007. Most people probably won't care about this, but I create batches of journal
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
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
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.
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
