Visual Basic For Applications using Excel (VBA)

Learn how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

In this course, students will gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students will strengthen their knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Be an asset to your company with the knowledge you take from your Microsoft Excel computer training. Get Excel 2003 Introduction to VBA training today. Learn to master this software with a New Horizons computer training courses across the UK. Move your career ahead today, with one of our Microsoft Office training classes.

Duration:
Instructor-led Classroom Learning - 2 Day

Overview:
In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

Who Should Attend:
Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

At Course Completion:
Upon successful completion of this course, students will be able to: - develop macros - format worksheets - create an interactive worksheet - work with multiple worksheets - perform calculations

Outline:

Lesson 1: Simple Task Macros
Macro basics
Edit a macro
A toggle macro
Make VB code readable
Protecting Code

Lesson 2: Manage a task with macros
Stepping through a macro
R1C1 formula style
User Input
Relative Reference macro
Turn off Excel alerts
Assemble the pieces

Lesson 3: Exploring VB Objects
Excel Object Model
Objects, properties and methods:
Application
Workbook
Worksheet
AutoList
Object Browser
Help
Explore the Range object

Lesson 4: Conditional and Looping Control Structures
IF THEN ELSE statement on Msg Box
Input Box
Loops For each loop
Counter Loop
Do until loop

Lesson 5: User Defined Functions
Write a Function
If function
SELECT CASE statement
Use Excel function

Lesson 6: Debugging and Error Handling
Event Handling