Show findcourses.com as: Mobile

Visual Basic Techniques and Strategies

Lorman Education Services
Training overview
Professional Course
1 day

Course description

Visual Basic Techniques and Strategies

Find practical ways to automate tasks and build a better workflow.

Visual Basic® for Applications (VBA) is an event-driven programming language for Microsoft® Office Applications. It has powered Microsoft Excel®’s macros since the mid-1990s. VBA was built to work with and extend the abilities of Office applications.

Learn the various programming nuances of VBA and gain proficiency in creating procedures that run in response to specific events while developing forms to accept, validate, and display data along with debugging and error handling.

Who should attend?

This live webinar is designed for

  • business owners and managers
  • supervisors
  • associates
  • analysts
  • bookkeepers and accountants.

Training content

Review of the VBA Environment

  • When and Why to Use VBA
  • Review of the VBA Screen
  • Shortcuts

Objects

  • The Object Browser
  • Excel Objects and Hierarchy
  • Macros and VBA
  • Controls and Inputs

Procedures

  • Variables and Expressions
    • Arguments and Parameters
    • Declaring Variables
  • Functions
    • Using an InputBox
    • Creating an Excel Function
    • Automating Excel
  • Operators
    • Arithmetic Operators
    • Comparison Operators
    • Logical Operators
    • Concatenation Operators

Program Execution

  • If…End If
  • Do…Loop
  • For…Next

Debugging Code

  • Break Mode
    • Immediate Window
    • Watch Window
    • iLocals Window
  • Error Handling
    • On Error

Forms and Controls

  • The Toolbox

Designing Forms Using Controls

Certification / Credits

Learning Objectives

  • You will be able to describe how to design and implement objects and events.
  • You will be able to identify how to set up looping with Do loops and Do While loops.
  • You will be able to discuss the integration of macros and VBA.
  • You will be able to explain how to develop efficient procedures with correct syntax.

About Lorman Education Services

Lorman Education Services - Live and On-Demand Courses

Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...


Read more and show all training delivered by this supplier

Contact info

Lorman Education Services

Lorman Education Services
2510 Alpine Road
54702 Eau Claire Wisconsin

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote