Scribd
Upload
287 views1 page

Micro-VBA Syllabus Overview

This document outlines the syllabus for a course on Micro-VBA. The course covers topics such as introducing VBA and the Visual Basic Editor, object-oriented programming concepts, writing VBA code using loops, arrays, events and more. More advanced topics covered include creating user forms, class modules, add-ins, interacting with other Office applications like Word, Outlook, Access and PowerPoint, and advanced programming techniques. The course aims to take students beyond just recording macros to writing their own VBA code for automating procedures and developing advanced applications.

Uploaded by

2442230910
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
287 views1 page

Micro-VBA Syllabus Overview

This document outlines the syllabus for a course on Micro-VBA. The course covers topics such as introducing VBA and the Visual Basic Editor, object-oriented programming concepts, writing VBA code using loops, arrays, events and more. More advanced topics covered include creating user forms, class modules, add-ins, interacting with other Office applications like Word, Outlook, Access and PowerPoint, and advanced programming techniques. The course aims to take students beyond just recording macros to writing their own VBA code for automating procedures and developing advanced applications.

Uploaded by

2442230910
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

MICRO-VBA SYLLABUS

UNDERSTANDING THE BASIC


 Introducing VBA
 Getting Started with Macros
 Introducing the Visual Basic Editor
 Working in the VBE
DIVING DEEPET INTO VBA
 Object-oriented Programming — An Overview
 Variables, Data Types, and Constants
 Understanding Objects and Collections
 Making Decisions with VBA
BEYOND THE MACRA RECORDER: WRITING YOUR OWN CODE
 Repeating Actions with Loops
 Working with Arrays
 Automating Procedures with Worksheet Events
 Automating Procedures with Workbook Events
 Using Embedded Controls
 Programming Charts
 Programming PivotTables and PivotCharts
 User Defined Functions
Debugging Your Code
 ADVANCE PROGGRAMMING TECHNIQUES
 Creating UserForms
 UserForm Controls and Their Functions
 Advanced UserForms
 Class Modules
 Add-Ins
 Managing External Data
 Data Access with ActiveX Data
 Not Gone, Not Forgotten
INTERACTING WITH OTHER OFFICE APPLICATIONS
 Overview of Office Automation from Excel
 Working with Word from Excel
 Working with Outlook from Excel
 Working with Access from Excel
 Working with PowerPoint from Excel

Office No. 107, 1st Floor, Pawan Complex, Opp. Paras Wine, Ulhasnagar Station Road,Ulhasnagar - 421003,
9820410824 / 9819685808 www.neotech institute.com

You might also like