![chandoo excel vba examples chandoo excel vba examples](https://i.ytimg.com/vi/GzUzEDW6sY0/maxresdefault.jpg)
Since we dont know any VBA, we will use this recorder to record our actions and then we will see recorded instructions (called as code in computer lingo) to understand how VBA looks like. Excel has a built-in tape recorder, that listens and records everything you do, in Excel’s own language, ie VBA. This is where Excel’s tape recorder will help us. In order to write your first VBA program (or Macro), you need to know the language first. Note: If you are new computer programming, watch our Introduction to Programming Video before proceeding. What is a Macro then?Ī macro is nothing but a set of instructions you give Excel in the VBA language. Thus enabling you to program Excel so that you can automate a boring report, format a big&ugly chart, clean-up some messy data or just play some random noises. When you tell instructions to Excel in this VBA language, Excel can do what you tell it. This language is called as VBA (Visual Basic for Applications).
![chandoo excel vba examples chandoo excel vba examples](https://www.datanumen.com/blogs/wp-content/uploads/2016/09/1-Chandoo.org_.jpg)
Just like you and I, Excel has a language too, the one it can speak and understand. You may be fluent in English, Spanish, French, German or Vietnamese. But I also speak Hindi, English and Cutish (that is the language my 2 year old kids speak). My Top 10 Tips for Mastering VBA & Excel MacrosĮveryone has a language.Putting it all together – Your First VBA Application using Excel.Using Cells, Ranges & Other Objects in your Macros.Understanding Variables, Conditions & Loops in VBA.What is VBA & Writing your First VBA Macro in Excel.Please read the rest of the articles in this series by clicking below links. This article is part of our VBA Crash Course.