VBA Archives - Page 3 of 3 - Excel TV

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 reading

Turn 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 reading

Edit 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 reading

My 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 reading

One 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 reading

Completing 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 reading

Completing 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 reading

How 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 reading

Getting 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
>