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 |
