Training in Excel VBA – Intermediate Course

Additional Material: Download Course Slides Link

Recap of VBA concepts

  • Overview of the Excel object and collections hierarchy
  • Overview of procedures versus functions
  • Overview of variables and their scope
  • Overview of control and decision structures

Working with basic objects

  • Overview of useful Application object properties
  • Use of events attached to Workbook and Worksheet objects
  • Overview of useful Range object methods and properties
  • Use of VBA to sort sheets
  • Use of the Comment object
  • Error handling

User forms

  • Maintenance and display of a user form
  • Basic controls – Label, Text-Box, Command-Button
  • List items – List-Box, Combo-Box
  • Mouse-controlled items – Check-Box, Option-Button(Radio Button), Toggle-Button
  • Display items – Frame, Tab-Strip, Multi-Page, Scroll-Bar, Spin-Button, Image
  • Use of form events, procedures and functions

Using VBA to maintain Charts

  • Creation of a chart as a sheet or as an object within a sheet
  • Application of formats to different chart areas and items
  • Maintenance of data labels and values
  • Maintenance of key attributes

Using VBA to maintain pivot tables

  • Creation of a pivot table and definition of its source data
  • Manipulation of column and row headings
  • Manipulation of cell values
  • Application of grouping and filtering
  • Application of formats to different sections of a table

Register your interest in a Talk-IT Course

Course Interest

By sending this message you agree to the privacy policy.

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!

Scroll to Top