Quick Tip – Set RefEdit Boxes to Edit Mode
I don't know how often this happens to you but it drives me crazy! Assume that I've got a formula set up in a conditional format, named range or some other place that has a "RefEdit" control on it. I
I don't know how often this happens to you but it drives me crazy! Assume that I've got a formula set up in a conditional format, named range or some other place that has a "RefEdit" control on it. I
Okay, it's a simple application. Really simple. I wrote this as an easy project to break into VB.NET. I'm actually feeling pretty good about it though, as it took me a couple of hours to code a working game, never
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
