Microsoft Excel VBA

by Media Training Claim Listing

Harness the power of VBA to manage large and variable amounts of data. Learn best practice for writing and editing VBA code and improve your data's usability.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Media Training Logo

img Duration

2 Days

Course Details

What Will I Learn?

  •  Understand the VBA environment

  •  Debug code using VB editor

  •  Objects and Collections

  •  Message boxes, input boxes, forms

  •  Code execution and fix errors

  •  Free digital course assets

  •  Free post-course helpdesk support

 

Getting Started

• Displaying the Developer Tab

• Recording and running a Macro

• Macro-Enabled Workbooks

• Using the Visual Basic Editor

• The Development Environment

• Understanding Macro Security

 

Working with Procedures and Functions

• Understanding Modules

• Understanding Procedures

• Calling Procedures

• Creating a Function Procedure

• Working with the Code Editor

 

Understanding Objects

• Objects and Collections

• Working with Properties

• Using the With Statement

• Creating an Event Procedure

 

Using Expressions, Variables, and Intrinsic Functions

• Understanding Expressions and Statements

• Declaring Variables

• Understanding Data Types

• Using Intrinsic Functions

• Understanding Constants

• Declaring and using Object Variables

 

Controlling Program Execution

• Control-of-Flow Structures

• Working with Boolean Expressions

• Different types of Control-of-Flow structures

• Guidelines for use of Control-of-Flow Structures

 

Working with Forms and Controls

• Working with UserForm Properties, Events and Methods

• Working with different Controls

• SettingControl Appearance

• Populating a Control

• Adding Code to Controls

• Launching a Form in Code

 

Handling Errors

• Understanding Error Handling

• Writing an Error-Handling Routine

• Working with Inline Error Handling

  • London Branch

    36 Shad Thames, London

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy