VBA for Microsoft Excel

This course is for people who wish to improve their skills by using Visual Basic for Applications (VBA) to increase productivity using automation in Excel.

2 days course
4.50  (321 reviews)
What you will learn:
  • Record macros using the recorder and create an application using the recorder
  • Create user-defined functions and work with the VBA editor
  • Understand VBA concepts and features, create procedures and sub routines
  • Work with variables and Excel objects
  • Use standard programming techniques and concepts
  • Create and program custom forms
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to have attended the Microsoft Excel Advanced course or a working knowledge of the topics covered including recording Macros in Excel.

Topics covered in this training course
  • Macro security
  • Macro recorder overview
  • Record a macro
  • Run a recorded macro
  • Relative recording
  • Run a relative recording
  • View the module
  • Modify a recorded macro
  • Assign macros to the toolbar
  • Assign macros to buttons
  • Assign macros to the ribbon
  • Benefits of VBA
  • VBA terminology
  • Excel object model
  • Test in the immediate window
  • Parts of the visual basic editor screen
  • Create a module page
  • Write a procedure
  • Run a procedure
  • The application object
  • The workbooks object
  • Worksheets collection
  • Range object
  • Writing a procedure
  • Compile code
  • Step through code
  • Breakpoints
  • Add comments
  • Indent code
  • Bookmarks
  • Import, export and copy code
  • With structure
  • Print code
  • MsgBox statement
  • Understand variables
  • Variable data types
  • Create and use variables
  • Explicit variable declaration
  • InputBox function
  • Variable scope
  • Constants
  • Pass variables
  • IF statement
  • Error handling
  • Escape an endless loop
  • Select case
  • Looping – do loops and for loops
  • Create a user-defined function
  • Create an add-in to share code
  • Create a custom form
  • Add objects to a form
  • Name form objects
  • Add label controls to the form
  • Add combo boxes
  • Add option buttons
  • Add command buttons
  • Run a form
  • Setting tab order
  • Where does form code live?
  • Initialise a form
  • Close the form
  • Open the form
  • Process data entered in the form
  • R1C1 notation
  • Validate form controls
  • What is an event procedure
  • Write an event procedure
  • Worksheet events
  • Working with arrays
    Reset options
- +
Need your training approved? Get a quote
4.50
4.50
from 321 reviews
5/5
“Great structure, just the right detail. Overall happy. Thank you Annie!”
Annika, May 2019
5/5
“Very knowledgeable instructor. Very enthusiastic and engaging.”
Oliver, May 2019
5/5
Fabien, May 2019
5/5
“Annie was lovely and very knowledgeable. ”
Kelly, May 2019