Variables as we learned, are small chunks of computer memory used to store and retrieve a value. They call you everyday and do the same thing.Ī Loop is a set of instructions meant to be followed certain number of times. Sales 5000 is a condition.Īnd now the whole process of each of the 24 store managers calling you and reporting the daily sales is nothing but a loop. This sort of thing is nothing but a condition.Ī Condition is a logical check computer performs to test something. So anytime a manager reports values beyond this limit (500,5000), you spend some time discussing the business and learning what is going on. Lets just say, this threshold is $500 for low sales and $5000 for high sales. You then speak with the store manager for few extra minutes to understand what is going and how you can help. The value 6300 here is nothing but a variable.Ī Variable is a small chunk of computer’s memory used to store a value.Īlthough you don’t micro-manage, you are certainly concerned, whenever a “we are nuts” store reports sales that are too low or too high. Second manger says “$4,000”, the total now will be 6300. So first store says “$2,300” your total is 2300. Instead, as you call the store manager, you just mentally update the total. So you don’t really note down sale for every store. Now, you are not the kind of boss who micro-manages & nitpicks. At the end of every day, you call each of the 24 store managers and ask them how much sales they have made in that day. To make it colorful, lets call your stores “We are nuts” – a dry fruit and nuts store chain. So, to make it easy to understand, lets assume you run a bunch of stores across the town. If you are new to computer programming, you might think I am speaking legalese. In part 2 of our VBA Crash Course, we are going to learn what Variables, Conditions & Loops are and how to use them in Excel VBA. My Top 10 Tips for Mastering VBA & Excel Macros.

Putting it all together – Your First VBA Application using Excel.

Using Cells, Ranges & Other Objects in your Macros.

Understanding Variables, Conditions & Loops in VBA.

What is VBA & Writing your First VBA Macro in Excel.

Please read the rest of the articles in this series by clicking below links. This article is part of our VBA Crash Course.

Vba increment variable