Category: VBA

Excel VBA Tips and Tutorials.
Excel Macro How to’s.

Word Cloud Generator

Seeing word clouds (or tag clouds) in dashboards and web sites quite often, I decided to make one myself using Excel VBA. It is a...

For Each Loop (Excel VBA)

For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...

Select Case (Excel VBA)

Select Case Statement lets you execute several group of statements based on value of an expression. It works like CHOOSE Function in Excel.

For Next Loop (Excel VBA )

For Next loop repeats a statement for a specified number of times. This is your basic loop for alot of situations.  You will use it...

With End With Statement (Excel VBA)

Here is a statement that will save you alot of effort and time when coding your macros. With  End With Statement lets you work on...