Subtitles of the Movie

Well that concludes our look at macros. So let's review what we have learnt. Firstly, macros are an excellent way to quickly automate simple tasks. You don't need to learn the VBA programming language, and you can get started very easily. Beyond that though, macro recording does provide a launch pad into understanding VBA. We've seen how we can go into the VBA editor, and look at the code recorded. We can see how Excel does the job, which gets us along the way to learning VBA ourselves. Indeed we can even reuse the exact code by copying what's recorded and pasting it into our procedures that we are writing for ourselves. Macros do have limitations though. Like handling looping automatically - sure, we can run a macro repeatedly to perform tasks on a worksheet. It would be nice though if we could handle all that, repeated action automatically. And once we get into VBA, it's possible to do that. There's also user interaction, we can setup forms, and in other ways interact with the user a lot more effectively than we can do simply using macros. So the bottom line then is, start with macros, and then when they don't meet your needs, move on to VBA to increase the power of your Excel automation.