Variables and Data Types

Variables are like boxes. You can change the contents of the box whenever you want and you can change the label of the box depending on what you want to put inside. Variables must not start with a number, must not have spaces, and must not contain symbols. For example, “Happy” is acceptable, “1Happy”, “Ha ppy”, and “Happy!” are all unacceptable variable names. Let’s make it easy and start with variable foo. Variable foo is undeclared at the moment, meaning he doesn’t know whether he is a string, integer, or other data type. First let’s see what foo can choose to be: (more…)

Why Do You Need It?

If you are reading this then you already found a reason why you want to learn Excel VBA. I will be using Microsoft Excel 2007 to demonstrate all the amazing things you can do. All versions of Microsoft Office have a Visual Basic Editor built right in, so you don’t need to buy anything extra. Note that, although you are learning Visual Basic through Excel, you could apply it to other applications that use Visual Basic as well.

Setting Up Your Workspace

Open up Excel 2007 and you will have an empty worksheet labeled Book1 or something along those lines. The first thing we want to do is get a developer tab. (more…)