This course introduces delegates to Visual Basic for Applications (VBA) for Microsoft Excel. It enables them to create simple code and macros using the Visual Basic language in order to automate formatting tasks and create custom functions. It is aimed at those who have a good working knowledge of Excel, but limited prior knowledge of VBA, who want to be able to automate tasks and extend the functionality of Excel further.
Create a Macro
Swap Values
Run Code from a Module
Macro Recorder
Use Relative References
Formula R1C1
Add a Macro to the Toolbar
Enable Macros
Protect Macro
MsgBox
MsgBox Function
InputBox Function
Worksheet and Worksheet Object
Path and FullName
Close and Open
Loop through Books and Sheets
Sales Calculator
Files in a Directory
Import Sheets
Programming Charts
Range Object
Current Region
Dynamic Range
Resize
Entire Rows and Columns
Offset
From Active Cell to Last Entry
Union and Intersect
Test a Selection
Possible Football Matches
Font and Background Colours
Areas Collection and Compare Ranges
Variables
Option Explicit
Variable Scope
Life of Variables
Type Mismatch
By actively participating in this course, you will learn about the following:
Using the Developer Tab.
Recording and running macros.
Swapping values in a macro.
Creating messages.
Understanding Workbook/Worksheet Objects and their properties.
Understanding how to declare Range, Cell, Row, and Column Objects.
Understanding variables such as Integers, Strings, Double and Boolean.
To ensure your success, we recommend that you have a reasonable working knowledge of Excel or have attended the courses detailed below:
Software Requirements for Virtual Classroom
If you are attending one of our Virtual Classroom courses, you will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on your device. You may notice differences in software if using a MAC. For the best experience we also recommend that you have two screens and a working microphone. A webcam is optional, but very much appreciated by our trainers!
This course is perfect for people who wish to gain the skills necessary to create macros and custom functions and understand the terminology and behaviour of the Visual Basic language.
