VBA IDE vs VS2008 IDE
On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms
On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms
Further to yesterday's post, I've found that the issue with onLoad conflicts is much bigger than I thought. As Bob Phillips pointed out, this isn't actually a new issue, or one that is strictly an issue with RibbonX, but it
I ran into this the other day when I was working on a file and it drove me nuts. Background: I always use a custom property to contain my RibbonUI object. It's set up like this: The following code goes
I was working on my budget package today, and decided that I wanted to break the text so that it showed on two lines. For many novice users this means that they put one or two words in one cell,
My wife sent me a message today to let me know that a review copy of Professional Excel Development: 2nd Edition had just arrived at my door. 🙂 The last version of the book was excellent: the only book on
A Little Background My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter
I recently taught a course and, while this wasn't actually covered in the course content, we did discuss it. I've found that every time I demonstrate this technique, it gets some "oohs" and "aahs", so I figured that I'd share
I really like the new icon sets that are in Excel 2007. They're kind of a neat way to format a cell to show interpretive information at a glance. One practical place to use these is as an alternative to
In a blog post last week, I was looking at the image formats to use when I snapped a picture of a chart. I'm kind of glad that Jon agreed with my assessment on EMF being the best image format
*Note: The charts in this post are based on sample data and do not reflect any real financial performance. In setting up my first dashboard, I took a page out of Charley Kyd's book and placed a bunch of little graphs
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
