Avoid using the mouse: When possible, use keyboard shortcuts instead of the mouse to perform actions while recording a macro.While using Record Macro as a learning tool pay attention to:įew more tips for recording macros in Excel: It allows to make few clicks and see how those clicks should be written in code. While learning VBA and also later on during work, you might find that Record Macro is very useful. Now, in addition to recording macros you can also independently write your own procedures. Visual Basic for Application appeared in Excel (Excel version 5) in 1994, earlier (up to version 4) only allow macros to automate those tasks that you can perform using the keyboard. You can find VBA in all Microsoft Office applications, AutoCAD, WordPerfect and many others. VBA is used for automation operations in applications such as Microsoft Excel and also expands it's capabilities. Visual Basic for Applications is simplified impementation of Microsoft's programming language Visual Basic 6. 2.2 Customization of Visual Basic Editor.

Excel with vba tutorial