Macros and VBA Programming

inquire@insightsmanila.com
0977.103.1800

Macros and VBA Programming

This training contains the essential of VBA knowledge. It prepares the user to explore more advanced techniques in VBA. There will be several exercises to apply the new skills learned every chapter.

Participants will be able to automate reports to improve efficiency, lessen errors, and lessen the impact to productivity when a skilled person resigns.

Part 1. Macro Recording

Creating Macros
Exploring Macro Security
Recording and Running a Macro
Using Relative Reference
Assigning a Macro to Buttons
Using Macro Recording to Create VBA Codes

Part 2. Introduction to VBA

Exploring the VBA Interface (Overview)
VBA Terminologies
Exploring the Properties Window
Exploring the Code Window

Part 3. Programming Basics

Essential VBA Codes
Different Ways of Calling Cells
Creating Basic Modules
Objects, Properties, and Actions
Dealing with Rows, Columns, and Sheets

Part 4. Control Structures

Applying Decision Structures
- If, Then, Else Statement
- If, Then, ElseIf Statement
Solving Repetitive Tasks with Loop Structures
- For, Next Loop
- For Each, Next Loop
- Do Until, Loop
Applying Control Structures in Excel Programs

Part 5. Creating Your Own Functions