OK, so I know a few days ago I said I had written my ...

Read More

In a previous tip, I had complained about form control option buttons. I had ...

Read More

Written by Bjoern Stiel Add-Ins are a great way to increase Excel’s firepower. Add-Ins not ...

Read More

In the first part of my manifesto, I outlined why I think we should ...

Read More

A little while ago, I made a blog post on why I think we ...

Read More

Most of us code using the Hungarian notation style when writing VBA code. Basically, ...

Read More

Wishing everyone a happy holiday and a terrific new year! Download file: Happy Holidays.xlsm ...

Read More

First of all, happy spreadsheet day! It was on this date today that VisiCalc ...

Read More

Disclaimer: The following tutorial requires Conditional Formatting which is a feature of Excel 2010 ...

Read More

This is part of a series called “VBA4Play,” written in conjunction with Excel game ...

Read More

Various people have written to me asking what they should do about popups generated ...

Read More

In my opinion, these are the two worst Excel errors ever: Code execution has ...

Read More

Every once in a while, I have a spreadsheet that sits in my ‘lab’ ...

Read More

I want to highlight two applications of the rollover technique that are really quite ...

Read More

A reader on one of the LinkedIn Excel Groups recently asked how to delete ...

Read More

Do you work with different series in your Excel charts? Here is what I would ...

Read More

Hello World! (Sorry, I could not resist J) I was recently asked by our ...

Read More

Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state ...

Read More

Alright, so this seemed like the next logical step for the rollover method: This ...

Read More

So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started ...

Read More

More people are interested in Excel mouse rollovers, which I think is great. I’m ...

Read More

When I’m all done with my Excel application, I’ll usually want to flip off ...

Read More

In my last post I used my patented rollover technique to create an effect similar ...

Read More

Before we start, you might have noticed some renovations on this blog. Yeah, it ...

Read More

First, a big thank you to everyone following my blog. Here’s some stuff I’d ...

Read More

Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool ...

Read More

So I’ve created a spreadsheet program that will import a selected bitmap and use ...

Read More

This is a long overdue article, my apologies. The basis of the article surrounds ...

Read More

So you’ve got a project that requires VBA – you’re ready and excited – and you ...

Read More

Anyone who has a made a dashboard in Excel before has probably experienced this ...

Read More

Now that I actually have some traffic to this blog, it’s probably time I ...

Read More

Now that I actually have some traffic to this blog, it’s probably time I ...

Read More

Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available ...

Read More