VBA Select Case – A Complete Guide

VBA Select Case – A Complete Guide

The Select Case statement is an alternative way to write If/ElseIf statements. You will find a Select Case statement equivalent in most popular programming languages. In many languages, the equivalent statement is the Switch statement. For example, the languages Java,...
The Excel VBA Dim Statement – A Complete Guide (Video)

VBA Dim – A Complete Guide

“One man’s constant is another man’s variable.” – Alan Perlis   This post provides a complete guide to using the VBA Dim statement. The first section provides a quick guide to using the Dim statement including examples and the format of the Dim...
VBA For Loop (Video)

VBA For Loop (Video)

Webinar Number: W0012 This webinar provides an in-depth guide to using the For Loop in VBA. It is based on this article on the For Loop.   Related Links The Ultimate VBA Tutorial Part One The VBA Dictionary The VBA Collection The ArrayList(Vault Only) (NOTE:...