Visual Basic for Applications

1. INTRODUCTION

i). What is VBA
ii). Basic Features of VBA
iii). VBE Environment
iv). What kind of things can you do with it?
v). Use this technology within existing projects.

2. VISUAL BASIC EDITOR

i). Recording macros
ii). Adding modules
iii). Browsing objects and variables
iv). Adding userforms
v). Saving a macro enabled workbook

3. WORKING WITH LOOPS

i). For-Next loop
ii). For Each -Next loop
iii). Do While loop
iv). Do Until loop
v). Countif(s)

4. APPLICATION OF LOOPS

i). Copying data from one sheet to another
ii). Calculations from different sheets
iii). Automating routine tasks

5. FUNCTIONS IN VBA

i). How to write UDF in VBA
ii). Calling UDF in excel
iii). When to use UDF
iv). Replicating an excel function
v). Function example

6.SUB ROUTINE IN VBA

i). When to apply Sub routines
ii). How to write sub routines
iii). Linking sub routines
iv). Running a sub routine in excel
v). Attaching a macro to a button or shape
vi). Debugging a macro

7. USER FORM IN VBA

i). Define User forms
ii). Tools to use on the user from
iii). Events and Properties
iv). Restricting users to enter specific data
v). Recording data into excel using user form

8. Mini Model in VBA

i). Comprehensive exercise



Proggramming Courses