Category Archives for VBA
Guest Post #1 – Dynamic Funnel Chart
Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool creation based on the Rollover technique I created. I asked if I could post his work to this blog to which he graciously agreed. Below is his write up. Some of the Excel functions below are in Dutch (which I think is […]
Continue readingTurn an Excel Spreadsheet into a Bitmap Image
So I’ve created a spreadsheet program that will import a selected bitmap and use Excel as a canvas to display it. Each cell is a pixel. Here’s a picture of president Obama in 8-bit glory: And here’s my current March Madness bracket in stunning 24-bit: You can download the file below, and instructions are included […]
Continue readingEdit button, please
This is a long overdue article, my apologies. The basis of the article surrounds a question in the comments section of an article on Chandoo.org (comment #75) written about the hyperlink() method I discovered and wrote about here. In Chandoo’s example, when a user rolls over different “hotspots” representing different datasets, the corresponding data comes into […]
Continue readingMy Top 5 VBA Development Environment Tips
So you’ve got a project that requires VBA – you’re ready and excited – and you jump right in! But here come the headaches! With every syntax error the visual basic environment interrupts your programming mojo with an annoying popup. You remembered to place comments in your code – but where are the ones you’re looking for? […]
Continue readingOne Size Fits All
Anyone who has a made a dashboard in Excel before has probably experienced this problem: a dashboard that fits nicely on your screen but not so nicely on your client’s. Yes, it’s the age old problem of differing monitors, resolutions, font-sizes and other settings that make what looks great on your screen look too small […]
Continue readingCompleting the Square aka The "Most" Squares Method
Now that I actually have some traffic to this blog, it’s probably time I started adding posts. A while ago, I was wondering how to make the cells in Excel exactly square, like the squares on graph paper. I came across this post from Mr. Excel. I wasn’t in love with his solution because it […]
Continue readingCompleting the Square aka The "Most" Squares Method
Now that I actually have some traffic to this blog, it’s probably time I started adding posts. A while ago, I was wondering how to make the cells in Excel exactly square, like the squares on graph paper. I came across this post from Mr. Excel. I wasn’t in love with his solution because it […]
Continue readingHow to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell
“Rollover B8 OV1” (like Rollover Beethoven…? get it?)Update 17 July 2011: This blog entry was featured in Chandoo’s latest post. So if you’re coming here from his site — welcome! original post: This post was inspired by Chandoo’s post on hyperlinks in Excel. If you haven’t checked his website out yet – you should. It’s […]
Continue readingGetting a Handle on hWnd
Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available through Visual Basic for Applications (VBA). For example, both eliminating the “Close”-button or creating a more opaque background on a window require the use of the Windows API. Doing this in Visual Basic isn’t too hard, but there are some distinct […]
Continue reading