OK, so I know a few days ago I said I had written my ...
- Home
- |
- Category: zVBA
In a previous tip, I had complained about form control option buttons. I had ...
This is part 2 in which I explain how I solved the problem. Make ...
Written by Bjoern Stiel Add-Ins are a great way to increase Excel’s firepower. Add-Ins not ...
In the first part of my manifesto, I outlined why I think we should ...
Most of us code using the Hungarian notation style when writing VBA code. Basically, ...
Wishing everyone a happy holiday and a terrific new year! Download file: Happy Holidays.xlsm ...
First of all, happy spreadsheet day! It was on this date today that VisiCalc ...
Disclaimer: The following tutorial requires Conditional Formatting which is a feature of Excel 2010 ...
This is part of a series called “VBA4Play,” written in conjunction with Excel game ...
Various people have written to me asking what they should do about popups generated ...
Edit: sorry for some of the squashed images you see in this and other ...
In my opinion, these are the two worst Excel errors ever: Code execution has ...
I want to highlight two applications of the rollover technique that are really quite ...
A reader on one of the LinkedIn Excel Groups recently asked how to delete ...
Do you work with different series in your Excel charts? Here is what I would ...
Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state ...
Alright, so this seemed like the next logical step for the rollover method: This ...
So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started ...
More people are interested in Excel mouse rollovers, which I think is great. I’m ...
When I’m all done with my Excel application, I’ll usually want to flip off ...
I’ve been on a real rollover kick lately. I’m really trying to figure out if ...
In my last post I used my patented rollover technique to create an effect similar ...
Before we start, you might have noticed some renovations on this blog. Yeah, it ...
Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool ...
So I’ve created a spreadsheet program that will import a selected bitmap and use ...
This is a long overdue article, my apologies. The basis of the article surrounds ...
So you’ve got a project that requires VBA – you’re ready and excited – and you ...
Anyone who has a made a dashboard in Excel before has probably experienced this ...
Now that I actually have some traffic to this blog, it’s probably time I ...
Now that I actually have some traffic to this blog, it’s probably time I ...
“Rollover B8 OV1” (like Rollover Beethoven…? get it?)Update 17 July 2011: This blog entry ...
Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available ...