VBA Courses

Microsoft VBA Courses Available

  • Course Description:
    This course is an introduction to Visual Basic for Applications using Excel. Macros are automated and edited using Visual Basic. Programming structures and programming principals are introduced at a beginner’s level.

    Duration:
    21 hours (3 days). If delegates know Excel to an Advanced level, the course can be completed in 2 days.

    Target Group:
    This course is intended for a delegate who knows Excel to an advanced level and wants to be able to edit macros with confidence.

    Prerequisites:
    The delegates must have a good knowledge of Excel.

    Method of training:
    Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topics
    Revision on Excel Functions, Named Ranges and Pivot Tables
    Security issues when creating workbooks with macros
    Personal Macro Wo rkbook
    Editing/Deleting Macros
    Understanding Relative and Absolute Macros
    Assigning Macros to Toolbars or objects or command buttons
    Understanding the Visual Basic Screen
    Performing a Macro on The Open Of A Workbook or on the click on a sheet, or an action that took place on a sheet.
    Show macros icons for a specific workbook only
    Determining The Last Row of a Range and coping formulae to the last row by using a macro.
    Coding To Protect/Unprotect Worksheets or Workbooks
    Using Variables
    The difference between Input Boxes and Message Boxes
    Using Userforms as an interface between the user and the program
    Understanding Private and Public procedures or functions
    The If Statement
    The Select Case Statement
    The For Next Loop
    Do Loop
    Debugging a Macro
    Creating VB Custom Functions
    Protecting the coding with a password
    Error Handling in procedures
    Using Arrays (Introduction)
    Projects to illustrate the importing of a text file and transferring data between workbooks
Microsoft Access

Our Courses

Microsoft Excel Course

Read More

Microsoft Word Course

Read More

Microsoft PowerPoint Course

Read More

Microsoft Access Course

Read More

Microsoft Oulook Course

Read More

Microsoft Excel Dashboard Reporting

Read More

VBA for Excel or VBA for Access

Read More

Microsoft Projects

Read More
Top