Excel and Visual Basic for Applications


Excel and Visual Basic for Applications


Duration: 4 days


Computer knowledge required:  You should be familiar with Excel and be able to calculate formulas and use functions – including the Sum, Max and Min functions.  You should also be familiar with Page Set-ups, including Headers and Footers.  Excel Advance is recommended.

You will learn to create and edit macros.  A macro is a series of commands and functions that are stored in a Visual Basic module and can be run whenever you need to perform the task.  Understanding the Visual Basic for Applications (VBA) programming language is important, so that you can write your own code for custom functions, to display message boxes for users, add input boxes where users can add information and you can also test the validation of the information.  You will examine sample code, learn how to create macros from scratch, and add your own code to previously created macros.  The course also includes useful Excel features to include in your macros.  You will also learn how to write code to work with different ranges, write decision-making code with IF and loop through code with FOR.  You will learn how to make your macro available with toolbar buttons, command buttons, and Add-ins.  You will lastly learn how to add dialog box controls to your spreadsheet, like lists, combo boxes, option buttons, etc.