Microsoft Power BI

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