Introduction to VBA Programming Training

Nivå: Intermediate
Snittbetyg: 4,7/5 4,70/5 Based on 166 Reviews

In this hands-on Introduction to VBA Programming training course, you gain a detailed understanding of how programming in Visual Basic for Applications (VBA) can increase productivity. With this VBA training, you learn how to automate repetitive tasks, build fully functional user interfaces, leverage tools for developing custom-built Microsoft Office solutions, and supercharge your productivity and the productivity of others.

Nyckelfunktioner:

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
  • After-course computing sandbox included

Du kommer lära dig att:

  • Develop custom solutions, automate tasks, and increase performance
  • Enhance the Office 2007-2016 Ribbon with new functionality
  • Exploit ActiveX controls to create functional and familiar UIs
  • Troubleshoot code using debugging tools
  • Secure your code and protect your users from macro viruses

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

Klassrum och självstudier

  • 4-day instructor-led training course
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

FÖRETAGSINTERN UTBILDNING

Teamträning

  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .

Klassrum och självstudier

Note: This course runs for 4 dagar

  • 7 - 10 jan 9:00 - 4:30 GMT London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 6 - 9 apr 9:00 - 4:30 BST London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 7 - 10 jul 9:00 - 4:30 BST London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 29 sep - 2 okt 9:00 - 4:30 BST London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 21 - 24 jan 9:00 - 4:30 EST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 31 mar - 3 apr 9:00 - 4:30 EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 5 - 8 maj 9:00 - 4:30 EDT New York / Online (AnyWare) New York / Online (AnyWare) Boka Din Kursplats

  • 21 - 24 jul 9:00 - 4:30 EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 29 sep - 2 okt 9:00 - 4:30 EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

VBA Introduction Course Information

  • Recommended Experience

    • Familiarity with Microsoft Office applications
  • Software

    • This course is applicable to all versions of Office, from 2007 to 2016

VBA Introduction Course Outline

  • Introduction

    The advantages of VBA

    • An easy-to-use and versatile language
    • Integrated with off-the-shelf products

    Macros: the first step

    • Recording and executing macros
    • Limitations
    • Enhancing with VBA code
  • Getting to Know the VBA Environment

    The code design tools

    • Project Explorer
    • Help system
    • Code Window
    • IntelliSense
    • Properties Window
    • Object Browser

    The debugging tools

    • Code stepping
    • Immediate Window
    • Breakpoints
  • Writing VBA Code

    Event-driven programming

    • The role of events in Windows
    • Responding to events through event procedures

    Putting objects to work

    • Properties
    • Methods
    • Events
    • Collections
    • Using With...End With

    Storing data in variables

    • How and when to declare variables
    • Selecting data types
    • Fixed and dynamic arrays
    • Constants

    Conditional branching

    • If...Then...Else
    • Select...Case

    Looping through code

    • Do...Loop, While and Until
    • For...Next and For Each...Next

    Building procedures

    • Creating Sub and Function procedures
    • Calling procedures
    • Passing arguments to procedures
  • Empowering VBA through the Application Object Models

    Understanding object model structures

    • Exploring the hierarchy with the Object Browser and Help
    • Referencing specific objects

    Writing application-specific procedures

    • Key objects within Excel, Word and Outlook
    • Creating templates and add-ins

    Exploiting the power of Automation

    • Controlling one Office application while working in another application
    • Accessing data in databases using ActiveX Data Objects
  • Building Intuitive User Interfaces

    Using intrinsic dialogs

    • Communicating with the user through the message box
    • Gathering user information with the input box
    • Utilising the FileDialog object and Dialogs collections

    Creating customised dialogs with UserForm objects

    • Command buttons
    • List and Combo boxes
    • Labels
    • Option buttons
    • Check boxes
    • Text boxes
    • Frames
    • Adding more functionality with advanced ActiveX controls

    Modifying menus and toolbars

    • Simplifying user interaction with the CommandBar object
    • Adding and removing CommandBarControl objects
  • Providing a Safe and Secure Environment

    Handling runtime errors

    • The On Error GoTo structure
    • Classifying errors with the Err object
    • Executing with Resume, Resume Next or Resume label

    Implementing security

    • The dangers of macro viruses
    • Macro security levels in Office
    • Applying digital signatures to macros
    • Password-protecting your VBA code

Teamträning

VBA Introduction Training FAQs

  • Can I learn VBA programming online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.

  • What versions of Microsoft Office is this course applicable for?

    This course is applicable to all versions of Office, from 2007 to 2016.

Questions about which training is right for you?

call 08-506 668 00




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition fee!
  • No advance payment required for most products.
  • Tuition fee can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

London / Online (AnyWare)
London / Online (AnyWare)
London / Online (AnyWare)
London / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français