Setup Menus in Admin Panel

Compu21

Setup Menus in Admin Panel

VBA / Excel Macros

VBA / Excel Macros Course Objectives: Increasing productivity when working with Excel data by leveraging the power of VAB. Getting …

0 STUDENTS ENROLLED

    VBA / Excel Macros

    Course Objectives:

    • Increasing productivity when working with Excel data by leveraging the power of VAB.
    • Getting well-grounded in the language in preparation for Excel development while extending your general programming potential in other applicable Microsoft Office applications.
    • Familiarization with the core objects in the Excel object model.
    • Building solutions for conceptual and realistic problems into Excel.

    Module 1

    • Preliminary comments on VBA
    • Power and value of this language
    • Limits and restrictions of the standard Excel User Interface
    • Extending Excel’s built-in capabilities
    • Survey of general solutions
    • Visual Basic Editor (VBE)/Integrated Development Environment (IDE)

    Module 2

    • Building code automatically
    • The role of variables and constants
    • Data Types
    • Variable and procedure scopes
    • Enumerations
    • Arrays
    • Naming convections
    • Object Browser

    Module 3

    • Control flow – beyond linear execution
    • If…Then statement
    • For…Next statement
    • For each statement
    • Do loop statement
    • Select Case statement
    • Interacting with the user & collecting inputs

    Module 4

    • Writing subroutines
    • Calling a subroutine
    • Creating code shells
    • Parameters to a procedure
    • ByRef and ByVal purposes
    • Writing functions
    • Calling functions
    • Terminating a program arbitrarily
    • Linking to external projects and libraries

    Module 5

    • Workbooks object
    • Core members
    • Workbook object
    • Core members
    • Worksheet object
    • Core members
    • Range object
    • Core members
    • Error handling to boost program robustness
    • Trouble-shooting/Debugging

    Module 6

    • User Form:
    • As central I/O point
    • For improving Excel real estate
    • Consolidated controls
    • Guides decision making
    • Data validations
    • Providing choices to the user
    • Miscellaneous topics

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts