Breaking Tab and Enter key navigation
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
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.
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.
