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 readingSo 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 readingThis 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 readingSo 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 readingAnyone 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 readingNow 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 readingNow 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 reading“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 readingSometimes, 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