Mac Excel VBA Macros

Training

Inhouse

Price on request

Description

  • Type

    Training

  • Methodology

    Inhouse

To develop automated procedures in Excel using the Visual Basic for Applications language.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Contents

What is a Macro?

Concept and discussion

The Visual Basic Interface

  • The Project Window
  • Code Window
  • Properties Window
  • Navigating between Excel and the VB Editor

Recorded Macros

  • Record New Macro
  • Assigning a keyboard short cut
  • Saving with the file

Methods of Executing

  • Menu
  • Visual Basic Toolbar
  • Keyboard Shortcut
  • Custom Toolbar Button
  • Custom Menu Item
  • Button
  • Alt [F8]
  • Forms Toolbar

Editing the Code

  • Using the Visual Basic Editor
  • Structure of a sub routine
  • Describe the colour scheme of Key Words
  • Navigation in a Module
  • Editing in a module
  • Use of Function Keys
  • Reassign keyboard shortcut
  • Run subroutines together

Checking For Errors

  • Debugging
  • Step Mode
  • Immediate Window
  • Object Browser
  • Toggle Breakpoint
  • Help system

Types of Recording

  • Relative
  • Absolute

Portability

  • Personal Macro Workbook
  • This Work Book
  • New Workbook
  • Add-ins

Creating New Functions

  • Uses
  • Function Keyword
  • Use of Arguments
  • Variables
  • Constants

Additional information

Payment options: * 1-to-1 training courses are charged at £450 per day. * Training at your venue is for £595 per day. If required, laptops are available at an additional £150 per day. * For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.

Mac Excel VBA Macros

Price on request