This tutorial covers; In this lesson we create a macro from scratch and begin to write our first code.Its a simple little bit of code to start with so we begin to understand the VBA object model and get familiar with VBA terminology and grammar.In just a few hours you can be writing your own macros to perform complex tasks and automate reports.Areas covered include; All through the course - the content is great, but the audio quality is a bit hissy, not as good as on some other courses.There are many different techniques for doing this.

It will generate code for you quicker than you can type, and help you learn the VBA for specific Excel commands you have not written before.

Macros will not be available in files saved as a workbook.

Depending on the user’s settings, a user will be prompted to enable macros on the spreadsheet when opening the file.

This tutorial covers; After recording a macro you will need some way of initialising it.

This will commonly come in the form of a button, and the most popular place to position that button is the Quick Access Toolbar.