VBA Archives - Page 2 of 3 - Excel TV

Category Archives for VBA

The two WORST Excel Errors EVER

In my opinion, these are the two worst Excel errors ever: Code execution has been interrupted, and There was a problem sending the command to the program A casual Google search will show these errors are as common as they are arcane. Below I’m going to detail my experiences with these errors and how I’ve […]

Continue reading

The Excel Lab: Soundex Search

Every once in a while, I have a spreadsheet that sits in my ‘lab’ for way too long. At a certain point, I have to admit that I’m never going to finish it completely or do a full blog post on it. I’ve decided just to release one such spreadsheet as is. Perhaps you will […]

Continue reading

Two Great Applications of Rollovers

I want to highlight two applications of the rollover technique that are really quite phenomenal. Square Charts and Treemaps in Excel If you haven’t seen the work of the Frankens Team yet – you’re missing out. They’re a group of…geniuses, really…who investigate and push Excel’s limit. Very recently, they wrote on the development of square […]

Continue reading

Gangnam Cell Styles…Delete

A reader on one of the LinkedIn Excel Groups recently asked how to delete cell styles from a workbook. Today, I’ll show a possible solution. The Cell Styles Group: List Cell Styles: I opened a workbook, Alt+F11 for the Visual Basic Editor and cooked up the code below. I then opened another workbook and made […]

Continue reading

Are You Series(ous)?

Do you work with different series in your Excel charts? Here is what I would like the final chart to loo like. Note the white dashed lines in front of the columns: Setup: I started with the chart I ended with in my last post, Points Of Interest. I then added some data to a separate […]

Continue reading

Points Of Interest

Hello World! (Sorry, I could not resist J) I was recently asked by our host, Jordan, if I would be interested in being a guest author here at Option Explicit VBA. I quickly and humbly accepted. I will strive to do my best to add something of value. Let’s dive right in.I was inspired the […]

Continue reading

Interactive United States 2012 Presidential Scoreboard in Excel

Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state to toggle through its party selection. Click on one of the three selections above to change scenarios. In the next month or so, I’ll be putting together a tutorial on this. But in the meantime, have some fun. Download. Ask questions […]

Continue reading

Interactive Map in Excel using Rollovers

Alright, so this seemed like the next logical step for the rollover method: This one is kinda complicated, I admit. Unfortunately, I didn’t really take the time to clean up the spreadsheet file for others to follow (I don’t really have the time these days). Sorry. But try to take it apart – and ask […]

Continue reading

Details on Demand: Bring up details on a graph with Excel rollovers

So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started experimenting with adding the capability to rollover a point on a chart (instead of just a worksheet cell) to see if I could have a label appear – or just some event fire – upon the mouse entering a chart’s datapoint’s […]

Continue reading

Needs More Rollover: Quick Tip!

More people are interested in Excel mouse rollovers, which I think is great. I’m especially enthusiastic about Chandoo’s latest dashboard contest where I found out that several contestants used the technique! By the way, there are many great dashboards showcased in the contest. Take a look and make sure to vote! So here’s the tip. If […]

Continue reading

Turn Off Cell Background Error Checking with VBA

When I’m all done with my Excel application, I’ll usually want to flip off background error checking – that is, I’ll tell Excel to stop showing those little green triangles that appear in cells. Don’t get me wrong, those little green alerts can be useful – but they are rarely so in a finished product […]

Continue reading

Interactive Periodic Table of Elements in Excel

I’ve been on a real rollover kick lately. I’m really trying to figure out if it can be useful. Earlier today I started making a Periodic Table of Elements using Excel. I employed the rollover technique to allow the user to gain information about an element simply by rolling over a cell. Well, for some reason, […]

Continue reading

How to: highlighting cells using the rollover technique in Excel

In my last post I used my patented rollover technique to create an effect similar to the one shown below: Neat, huh? When you place your mouse over a cell, it changes color to show that you are selecting it. It’s a true “rollover”: no mouse-clicks required. In my last post, I show how that might […]

Continue reading

Rollovers for Gantt Charts

Before we start, you might have noticed some renovations on this blog. Yeah, it was time for a change. I’m working this template out, so sorry if some of the formats seem off. Also, I have started a new facebook page. I’ll be keeping it updated with stories from my favorite blogs. Also, you can […]

Continue reading

Miscellaneous Stuff

First, a big thank you to everyone following my blog. Here’s some stuff I’d like to share in no particular order. Stephen Colbert Come to My Wedding We (my fiance and I) want Stephen Colbert to come to our wedding, which is in October of this year. My beautiful and wonderful fiance explains as follows: During the […]

Continue reading
>