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

Family Computers is one of the pioneering companies to open computer training centre in Qatar and provides training services to corporate houses and individuals alike.  we provide training for a wide range of topics related to computers and have trained in excess of 40,000 students. A figure which is more than most of the training providers put together.

We are always in the forefront in launching job oriented, practical computer training courses. We emphasis on the importance of individual attention to students and limited students in a batch. This also helps us to improve the quality of our service.

See all Family Computer Center courses

Contact information not available.

Courses you can instantly connect with... Microsoft Excel Training New Horizons Doha

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or