Free Excel Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Excel.

Excel Assessment

Free Microsoft Word Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Word.

Word Assessment

Free PowerPoint Skills Assessment

Very short questionnaire to establish your skill level with Microsoft PowerPoint.

PowerPoint Assessment

VBA and Macros in Excel - Explained

Top Training Company for 7th Year in a Row Top Training Company for 7th Year in a Row
Previous Article
Free Windows Server 2016 Clinic and Lab Free Windows Server 2016 Clinic and Lab
Next Article
 

VBA (Visual Basic for Applications) is the programming language of Excel that allows you to automate tasks utilising what we call macros. Basically, VBA is the tool we use to develop programs to control and automate functions in Excel.

Well probably the best way to understand it, is to see how it's done.

How to record and then view the recorded VBA code

Go to the Developer tab (If not already enabled) go to File>>Options>>Customise Ribbon>>Tick the “Developer” tab

Click record Macro

 Once you do that you get the following pop up for Recording the Macro:

This gives you the option to name, create a shortcut, store the Macro and add a description.

Once you have filled in the details, click OK to start recording your first Macro.

There are millions of steps and repeated procedures that you can perform for use with a Macro.

When you are finished recording the steps for your Macro, click the stop Square recording button in the Code group.

To Play, edit etc… Click Marcos button in the Code group

Options let you add a description or to edit or create a shortcut.

Edit option will let you edit the actual code in VBA for the steps you recorded in your Macro.

Macro edit pane

For more on recording Macros and VBA please see our Excel Part 3 course and our Excel VBA course.

 


 

You may also be interested int he following courses:

 

/ Author: Liam Phelan / Number of views: 7956 / Comments: 0 /
Print

Theme picker

Loader

Categories

Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.

Subscribe


Follow us on Linkedin for the lastest cheat sheets and learning resources