Microsoft Excel Power

Lesson 2: The Basics of VBA

Conclusion

The key to writing successful macros is understanding the requirements the macro has to satisfy, once you know that, the rest just comes with practice. Read the texts and use the macro record feature to learn about the code. Remember, most things that you can do by hand in Excel you can record. Then all you have to do is take these code snippets and place some control logic around them.

In the next couple of lessons we will look at some real problems that I had to solve. I will show you how I go about creating a macro to satisfy the requirements that I know about, we will also talk about the requirements you don't know about!

  1  2  3  4  5