Scribd Logo
Upload

Welcome to Scribd!

  • 160 views

    VBA MACRO Course Training Syllabus PDF

    Uploaded by

    2442230910
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    VBA MACRO Course Training Syllabus PDF

    Uploaded by

    2442230910
    160 views1 page
    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.

    Original Title

    VBA-MACRO-course-training-syllabus.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    160 views1 page

    VBA MACRO Course Training Syllabus PDF

    Uploaded by

    2442230910
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 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