Excel Topic 2: Next Steps with Macros Part 1
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to use VBA code to refine or adapt macros.
Course Objectives:
A macro is a recording of a step or a series of steps that can be run as many times as required. Use VBA to refine or adapt macros in order to suit specific requirements. Participants should have attended the Introduction to Macros webinar prior to attending.
Course Outline:
Course Introduction
Recap on Introduction to Macros
Using the VBA Editor
Recognising Different Objects in VBA
Using Dim to Define Objects
Using Message Boxes to Prompt Users and Display Data
Using Input Boxes to Capture Data
Understanding the Visual Basic Editor Window
Managing Program Control Statements
Creating Iterative Loops
Saving a File Using a Macro
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.