A brief discussion about the differences between macros and VBA, and how this course covers both.
Video time: 5m 10s
Entry level steps to allow the user to record macros in Excel.
Video time: 6m 19s
Recording a simple Macro in Excel.
Video time: 4m 30s
A discussion on which files types support macros, and why it is critical to save your work before moving forward.
Video time: 4m 32s
How to run a macro from the Macro dialog.
Video time: 5m 07s
How to run a macro from a keyboard shortcut.
Video time: 5m 05s
How to run your macro from a worksheet button.
Video time: 5m 27s
Meet the Visual Basic Editor (VBE) - your coding studio.
Video time: 5m 21s
A discussion of the different items you'll encounter as you learn to code, and how they relate to each other.
Video time: 5m 30s
A visual view of a portion of Excel's object model.
Video time: 5m 52s
Examining the different code containers and where you should place your code.
Video time: 4m 40s
Looking at the different keywords and structure that make up a valid macro.
Video time: 4m 38s
Editing the previously recorded code in order to remove unnecessary objects.
Video time: 6m 47s
How to step through a macro line by line in order to aid in debugging.
Video time: 5m 40s
How to set and use breakpoints during code development and debugging.
Video time: 5m 08s
A discussion of what variables are, and what they do for us when coding.
Video time: 5m 11s
Setting up variable dimensions and ensuring the code does so in the correct location.
Video time: 5m 45s
How to assign strings, values or objects to variables and use them in your code.
Video time: 7m 00s
Why forgetting to set a simple flag can burn you in the long term.
Video time: 6m 17s
Working with the locals window to help you debug and explore the object model.
Video time: 5m 29s
Exploring the benefits of the Immediate window for logging and querying, as well as writing when needed.
Video time: 6m 06s
How to use the Watch window to break code execution when variable conditions are met.
Video time: 5m 25s
How the Stop keyword can be used during code development similar to a breakpoint.
Video time: 5m 00s
How "With" blocks can tighten up your code and ensure your code targets the objects you expect.
Video time: 5m 31s
Implementing If/Then choices in VBA.
Video time: 6m 50s
Understanding how the Select Case construct adds another logic test to your coding arsenal.
Video time: 6m 12s
Basic looping including counting iterations and exiting.
More advanced looping by looping while or until a certain condition is met.
Video time: 5m 43s
Running a loop a set number of times.
Video time: 5m 17s
Using a For Each loop to cycle through each object in a collection such as each worksheet in a workbook's worksheets.
Setting up a master macro allowing you to call other macros from a single source.
Video time: 6m 21s
How to provide feedback to your user via the VBA MsgBox object.
Video time: 5m 55s
Identifying which button the user clicked when presented with a MsgBox in order to use their response in our code.
Video time: 6m 44s
Working with the VBA InputBox to prompt the user to enter information and capture it for later use.
Video time: 5m 46s
Forcing users to enter data when requested.
How to trigger various errors in VBA, and what they mean.
How to set up an error trap in VBA to handle errors.
Video time: 5m 14s
Setting up an error handling section for your macro.
The syntax signature for a UDF and how it differs from a standard subroutine.
Video time: 3m 57s
Creating a UDF to return the user name.
Video time: 5m 41s
Calling a UDF from a worksheet and from VBA.
Video time: 5m 23s
Share this course
Please confirm the name that should appear on the certificate
Warning! Once you have confirmed, you will not be able to change it. If you have accidentally misspelled this name, please contact us at email@example.com.
Start a tour to see how the lessons work
or dive right into your course. You can always access the tour at a later time.
How is your GoSkills experience?
Your feedback has been sent
© 2020 GoSkills Ltd. Skills for career advancement