This course will benefit all those who wish to use Visual Basic for Applications (VBA) to create macros for automating repetitive tasks in Excel.
Course Objectives:
To be able to:
- Develop macros.
- Format worksheets.
- Create an interactive worksheet.
- Work with multiple worksheets.
- Perform calculations.
Who is the target audience?
This course has been designed for the beginners to help them understand the basics of VBA.This course will provide enough understanding on VBA from where you can take yourself to a higher level of expertise.
REVIEW OF DEVELOPING MACROS
- Create a Macro with the Macro Recorder
- Edit a Macro
- Debug a Macro
- Different ways of running a Macro
THE VISUAL BASIC ENVIRONMENT
- The Project Explorer
- Properties
- Object Viewer
WRITING VBA CODE
- Properties
- Methods
- Objects
- Subroutines
- Immediate Window
- Watch Window
PERFORMING CALCULATIONS
- Create User-defined Functions
- Automate SUM Functions
COMMUNICATING WITH THE USER
- Simple Message Boxes
- Message boxes that return values
- Buttons and icons
- Input Boxes
VARIABLES
- Declaring Variables
- Using Variables
- Watching Variables
CONTROL AND DECISION STRUCTURES
- Conditional Statements
- Decision Structures
- Select Case
LOOPING
- For next loops
- Do While
- Do Until
ERROR TRAPPING
- Understanding error handling
- Understanding VBA error trapping options
- Trapping errors with the on error statement
- Understanding the error object
- Writing an error handling routine
- Working with inline error handling
DEBUGGING THE CODE
- Defining errors
- Working with debugging tools
- Determining breakpoints
- How to step through code
- Working with break mode during run mode
- Identifying the value of expressions
EVENT PROCEDURES
USER FORMS
- Placing controls
- Aligning Controls
- Properties
Muhammad Fahid
