Visual Basic for Excel 365 Fundamentals – Excel VBA. Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course: 9007

You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.

Download PDF
  • Duration: 2 days
  • Price: $895.00
Get This Course $895.00
August 8 - 9

9:00 AM – 4:00 PM CST

September 12 - 13

9:00 AM – 4:00 PM CST

October 10 - 11

9:00 AM – 4:00 PM CST

November 14 - 15

9:00 AM – 4:00 PM CST

December 12 - 13

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

Visual Basic for Excel 365 Fundamentals – Excel VBA

Visual Basic for Excel 365 Fundamentals – Excel VBA. Versions 2013, 2016, 2019, Office 365, & Online are also available.

Are you facing a repetitive clean-up of fifty tables in Excel? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?

You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.

Course Outline

Lesson 1 – Excel Macros

  • Macro Introductions
  • Running Macros
  • Macro Examples

Lesson 2 – Visual Basic Editor

  • Interface
  • Coding Components
  • Debugging and Running Code
  • Optional Topics

Lesson 3 – Cell Manipulation

  • Cell Identification
  • Cell manipulation
  • Column and row Techniques
  • Cell Offse, xlDowns, CurrentRegion, and Address

Lesson 4 – Formatting Techniques

  • Formatting
  • With Statements

Lesson 5 – simple, virtuals

  • simple, virtual Structure
  • Global Declarations
  • VB Arrays for Excel VBA

Lesson 6 – “IF” Statements

  • If Statements
  • Select Case Statements

Lesson 7 – Message and Input Boxes

  • MsgBox
  • Input Box
  • InputBox Method
  • User Form

Lesson 8 – Loop Control Structures

  • For Loops
  • Do Loops
  • Do While
  • While Wend Loops

Lesson 9- Worksheet and Workbook Manipulation

  • Worksheets
  • Workbooks

Lesson 10 – Functions

  • Excel Functions
  • Call – Calls Another Subroutine
  • Using Excel Formulas in VB Code
  • Run on Open

Lesson 11 – Custom Programming Techniques

  • Custom Function Library
  • Custom Functions

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961