Multithreaded VBA - An Approach To Processing Using VBScript

Posted on 25 January 2010

Today's guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A few months ago, I wrote a post on how one can simulate multithreading in VBA using Excel. Daniel picked up a thread from there and commented that he had some good success in marshalling some of windows multithreaded subsystems from within VBA. In this article he describes his approach. Multithreading VBA - Using VBScript Try as we might to work around ... Continue Reading

Comments (8)

Treemap in Excel - Coming Soon

Posted on 24 December 2009

Its been a few days since I posted. In case you were wondering what I was up to - yours truly was busy coding a program to create treemaps in Excel. Treemaps are interesting creatures. You can pack a few thousand data points in a single treemap and utilize just about the same space as any of the traditional charts. The term 'treemap', as we see it being used nowadays, actually refers to the inward growing members of the treemap ... Continue Reading

Comments (11)

VBA Select Case - Using VBA Select Case Statement in Excel

Posted on 20 December 2009

The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statements out of many based on what a given expressions evaluates to. In today's post we will look at some basic and intermediate ways in which it can be used when writing VBA code. Basic Form of the VBA Select Case Statement [cc lang="vb"] Select Case expression_to_test Case expression_value_1 : Code to Execute When expression_to_test = expression_value_1 Case ... Continue Reading

Comments     

Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software

Posted on 16 December 2009

In Six Sigma Control charts using Excel we saw how to make control charts using named ranges. From there on, it was a short hop to porting the logic to VBA. So here is the VBA code for automating the creation of a six sigma control charts. It has been tested with Excel 2000, Excel 2007 and Excel 2010. How to Use the Control Chart Program 1. Simply click the 'Make Control Chart' ... Continue Reading

Comments (2)

Slicer VBA Code - Create, Change or Modify a Pivot Table Slicer using VBA

Posted on 23 November 2009

Here is some VBA code that can help you automate working with a slicer in Excel. Slicers, as you would know, are the latest introduction to Excel. As I mentioned in my previous post, they can also be programattically controlled using simple VBA code. Let's see how. Slicer Creation using VBA - Basic Steps Let's look at the slicer hierarchy - a workbook has slicer caches (accessed the SlicerCaches object), each slicer cache in turn having multiple slicers (one for each ... Continue Reading

Comments (1)

Memory Game - Pattern Matching

Posted on 10 November 2009

I saw this memory game a few days back. The website promised an instant boost in the players memory if they played this game for a 4 week period. So if you've been wondering how to get that 'excel'-ent memory, here's the prefect game for you. The Memory Game The game is pretty straightforward. You are shown a grid of cells, some of which are colored and some are left blank. Once you've memorized the pattern of the colored cells, the ... Continue Reading

Comments