MS Excel 2010 VBA

Course details

This course is the perfect introduction to VBA (Visual Basic for Applications) and shows, how to use it to enhance Excel. It helps to learn how to work with the key objects and uncover the best ways to gain access to workbook, worksheets and many more. The person who have proficient knowledge of Microsoft Excel can learn this course to improve their computing skills using excel

Course Contents 

MODULE I: INTRODUCTION & BASICS OF MACRO

• Introducing Visual Basic for Applications
• Displaying Developer tab
• Recording a Macro
• Saving a Macro Enabled work book
• Running a macro
• Editing a Macro in Visual Basic editor
• Understanding the development environment
• Understanding Macro Security

MODULE II: WORKING WITH PROCEDURES AND FUNCTIONS

• Understanding Module
• Creating Standard Module
• Understanding Procedure
• Creating Procedure
• Creating Sub Procedures
• Calling Procedures
• Making function procedure
• Using the code editor

MODULE III: OBJECTS

• Understanding objects and collections
• Using the object browser
• Working with properties
• Understanding and using methods
• Event and Event procedure

MODULE IV: EXPRESSIONS & VARIABLES

• Data types
• Declaring variables
• Using Message box and Input Box
• Declaring and using object variables

MODULE V: CONTROLLING THE PROGRAME EXECUTION

• Decision Making Statements
• IF…….else
• Select case
• Looping Statements
• Do…..Loop
• For….To….Next
• For Each…..Next

MODULE VI: USER FORMS AND CONTROLS

• Understanding user form
• Using the toolbox
• Setting properties and adding codes to the controls
• Launching a form in code.

MODULE VII: DEBUGGING AND ERROR HANDLING

• Understanding errors and using debugging tools
• VBA’s error trapping options
• The On Error statement
• Error Handling routines