FROG Software Training: Excel 2010/2013/2016 VBA

FROG Software Training: Excel 2010/2013/2016 VBA

Do you regularly have to carry out the same procedure to organise your worksheets or documents? There is a quicker way, by automating using macros and enhancing with VBA.

Dates 27 Feb 2019 - 28 Feb 2019 - This event is in the past.
Opening times 09.30-16.30
Venue FROG, Great Shelford, Cambridge CB22 5NE
Organiser name Debby O'Gorman

Event details:

Description: Delegates will gain a general knowledge of VBA to use within Microsoft Office applications.

Pre-requisites: Delegates should be advanced level users of Microsoft Excel, although no previous programming knowledge is necessary.

What is Visual Basic for Applications?

  • An Introduction to Macros
  • Recording Macros
  • Running Macros

Understanding the Visual Basic Environment

  • The Visual Basic Editor
  • Understanding the syntax of your Macros
  • Editing Macros
  • Adding comments and documentation to your macros
  • Assigning VBA and Macros to keyboard shortcuts, icons and menus
  • With Statements
  • Managing Error Messages
  • Debugging Techniques
  • Working with Variables and Data TypesUser Defined Functions
  • Understand Objects and Collections
  • Add conditions to your macros

Communicate with the user

  • Message boxes
  • Input Boxes
  • Working with return values

Repeating Actions in VBA – Loops

  • Fixed loops
  • Flexible Loops

Customise Menus and Toolbars

Automation with Macros

Create Custom Dialog Boxes

FROG Software Training Limited

Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.

FROG Software Training Limited directory information