VBA For Microsoft Excel

by Elite Indigo Claim Listing

This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual BasicĀ® for Applications.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Elite Indigo Logo

img Duration

2 Days

Course Details

This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual Basic® for Applications.

 

At Course Completion:

  • Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Excel applications to write custom functions and event-driven procedures. 
  • Validate data.
  • Find and trap errors.
  • Loop through the collection of cells and worksheets to process some calculation.

 

Prerequisites:

  • Before beginning this course, students should be able to:
  • Extensive understanding of Microsoft Excel or previous version of Microsoft Excel
  • Basic programming knowledge in Visual Basic.

 

Course Outline:

  • Module 1
  • Creating a Simple Macro
  • Changing Multiple Properties at Once
  • Manipulating Recorded Properties
  • Editing A Recorded Macro
  • Make a Macro Do Simple Tasks
  • Module 2
  • Task One : Importing a Report file
  • Task Two : Filling In Missing Labels
  • Make a Macro Do Complex Tasks
  • Module 3
  • What is an object?
  • Understanding Workbooks
  • Understanding Worksheets
  • Explore Workbooks and worksheets
  • Module 4
  • Referring to a Range
  • Enhancing Recorded Selections
  • Entering Values and Formulas into a Range
  • Formatting a Range
  • Module 5
  • Using Conditionals
  • If-Then-Else
  • Select-Case
  • Do…Loop
  • For…Next
  • For Each…Next
  • Control Visual Basic
  • Creating Loops
  • Module 6
  • Creating a Custom Function
  • Type Of Errors
  • Error Handling
  • User Define Function and Error Trapping
  • Module 7
  • Creating Command Buttons
  • Assigning Macro to Button
  • George Town Branch

    51, Jalan Nuri 6, George Town

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