Skip to content
Laptop Screen and Graduation Mortarboard Hat icon image

Microsoft Excel - Next Steps with Macros Part 2

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:

This webinar will show users how to use VBA code to refine or adapt macros in order to suit specific requirements. Participants should have attended the Introduction to Macros webinar and the Next Steps with Macros – Part 1 webinar prior to this.

Course Outline:

Introduction and Overview

CONTENT

Recap - Part 1

  • Recap on Next Steps with Macros – Part 1

ActiveX Controls

  • Using Macros with ActiveX Controls
  • Working with Properties in ActiveX Controls

Using Forms

  • Creating User Entry Forms
  • Text and List Boxes
  • Check Boxes and Combo Boxes
  • Radio Buttons
  • Working with Variables

Import and Export Modules

  • Exporting and Importing Modules

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.