There is a pretty good chance that you've recorded a macro in Excel and a similar chance that you were not happy with the results. This isn't a requirement-it actually is a barrier to entry into the ranks of being a successful VBA programmer. I will assume that you are not a programmer, but that you might have taken a class in BASIC in high school. You probably know more than 90% of the people in your office. My assumption in writing this book is that you are pretty talented with a spreadsheet. This was not a good combination of events. I was now faced with a macro recorder that didn't work and a language that I could not understand. My company had just forced everyone to convert from Lotus 1-2-3 to Excel. To make matters worse, even in 1995, I was the spreadsheet wizard in my office. Next Steps: Learning VBA Is the Solution_28 Running the Macro on Another Day Produces Undesired Results 24 Understanding the Visual Basic Editor (VBE) 18Įxamining Code in the Programming Window 22 Overview of Recording, Storing,and Running a Macro 15 Knowing Your Tools-The Visual Basic Toolbar 13

Microsoft visual basic for excel 2003