Browsing articles in "Excel"
ilearnexcelvba

iLearn Excel VBA: Select-Case

By Peter Atoria  //  December 14th, 2011  //  Excel, Visual Basic  //  No Comments

The Forgotten Select-Case

The Select-Case is often ignored when programming as it can be easily substituted with If-Then-Else statements. It functions much like a If-Then-Else statement and computes a conditional where if true, completes a segment of code. Let’s look at the example: (more…)