Browsing articles from "August, 2011"
ilearnexcelvba

iLearn Excel VBA: For-Loop

By Peter Atoria  //  August 28th, 2011  //  Visual Basic  //  No Comments

For-Loops Spin You Right Round

The For-Loop is an iteration statement. An iteration statement is one that repeats a segment of code until a desired result is achieved. Each repetition is called an iteration. Again, it’s easier to learn by example: (more…)

ilearnexcelvba

iLearn Excel VBA: If-Then-Else

By Peter Atoria  //  August 27th, 2011  //  Visual Basic  //  No Comments

The Almighty If-Then-Else

The If-Then-Else is a perfect example of a conditional statement. A conditional statement is a true/false statement that is computed to determine if a code segment should be executed. Let’s have a look at a practical example: (more…)