round button
Drop Your Query/Message
Back to Top

VBA Course, VBA Class, VBA Classes , VBA course in Nagpur, VBA Classes Training Institutes and Projects in Nagpur - VBA Classes in Nagpur

                       VBA

MODULE 1; UNDERSTANDING  SECURITY LEVELS

Ø  WHY SECURITY

Ø  SECURITY LEVELS AND IT’S MEANING

MODULE  2;  FUNCTIONS

Ø  WHAT IS FUNCTION AND SUBROUTINE

Ø  WRITING FUNCTION USING VBA EDITOR

Ø  CALLING FUNCTION IN OTHER WORKBOOK

MODULE  3;RECORDING MACROS

Ø  RECORDING AND RUNNING MACRO

Ø  STORING IN DIFFERENT BOOKS

Ø  CREATING BUTTONS AND ASSINGNING MACRO TO IT

Ø  CREATING MY MENU

MODULE 4; THE VISUAL BASIC  EDITOR

Ø  EDITING MACROS USING VBA EDITOR

Ø  UNDERSTANDIND THE PROJECT EXPLORER

Ø  EXPLORING WINDOWS PROPERTIES

Ø  MODIFYING CODE IN CODE WINDOW

Ø  DEBUGGING CODE

MODULE  5;PROGRAMING FOUNDATION

Ø  VARIABLES ,DATA TYPE AND CONSTANT

Ø  ARRAYS

Ø  OBJECT VARIABLES

Ø  CONDITIONAL STRUCTURES( If….Then ,Select case )

Ø  LOGICAL OPERATORS

Ø  LOOPING CONSTRUCTS(For Loops, Do loops, While… Wend)

Ø  BUILT -IN FUNCTIONS

Ø  CREATING SUBROUTINES

 

MODULE   6; EXCEL  OBJECT MODEL

Ø  WORKING WITH OBJECTS- PROPERTIES, EVENTS AND METHODS

Ø  APPLICATION OBJECTS

Ø  WORKBOOK OBJECTS, WORKSHEET OBJECTS  AND RANGE OBJECTS

Ø  CHARTS OBJECTS

Ø  PIVOT TABLE  OBJECTS

MODULE   7; USER  FORMS

Ø    CREATING  FORMS 

Ø  FORM EVENTS     

Ø  CREATING CUSTOM MENUS AND TOOLBARS

Ø  CREATING ADD-INS

  MODULE   8; WORKING WITH OTHER APPLICATIONS

Ø  WORKING WORD, POWER POINT AND OTHER APPLICATION

 

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2023 All Right Reserved - Atlanta Computer Institute, Nagpur.
a