An ExcelVisual Basic for Applications VBA Programming Primer Form

Instructions and help about An ExcelVisual Basic For Applications VBA Programming Primer

Today I want to show you how you can  eliminate boring and repetitive tasks   in Microsoft Excel using something called  macros and VBA, or Visual Basic for   applications. With macros you can  automate those everyday tasks in Excel,   and by learning macros, you'll  look like a wizard in Excel. We're going to start with how to record just a  simple macro. Then I'll show you how you could   run it, how you can test it, how you could  run your macro in any spreadsheet at all. Then we'll also touch on some  concepts like using if statements   and setting up loops, and we'll look  at many different types of loops.   If you'd like to follow along today, I've  included a sample spreadsheet right up above   and down below in the description. All right, let's check this out. If you look at the definition of macro,  it's a single instruction that expands to   a set of instructions to  perform a particular task. But what does that actually mean? The best way to unders