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