Microsoft Excel VBA Programming

Training

Online

£ 75 VAT inc.

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    2 Weeks

  • Start date

    Different dates available

Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.

This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.

During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.

Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.

You can download all of the materials used in the lectures, so that you can follow along.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course


By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.

You will fully understand the purpose and syntax of each line of code that you write.

You will not simply be entering lines of code because you have been told they will produce a certain result.

You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.


Experienced Excel users who are new to Excel VBA programming.

Microsoft Excel 2016, 2013, 2010 or 2007 running on Windows 7, 8 or 10.

Certificate of completion

A free trail version of this course is available.


Sign up for the free trail version of this course. If it meets with your expectations, then enroll for the full course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Visual Basic training
  • Microsoft Excel
  • Syntax
  • Property
  • Visual Basic
  • Programming
  • Programming Application
  • Excel Formula
  • Microsoft excel training
  • MS Excel
  • Object-oriented programming
  • VBA (Microsoft Access / Office)

Teachers and trainers (1)

Microsoft Specialist

Microsoft Specialist

Experienced vba developer and trainer

Course programme

1. Getting Started

Download course practice files

1. Course introduction

2. Excel VBA overview

3. The Developer Tab

4. Macro security

5. The Visual Basic Editor and Project Explorer

6. Excel objects and event code

7. Writing a macro in the VBE

8. Using the Immediate window

9. Saving a macro-enabled workbook

10. The correct way to use the macro recorder

11. Analysing a recorded macro

12. Improving a recorded macro

13. Assigning a macro to a button

14. Testing a macro on another worksheet

2. Key Components of VBA Code

1. The Excel object model

2. VBA classes and functions

3. Properties and methods

4. Data variables

5. Object variables

6. Option explicit

7. Declaring And Using Constants

8. Using MsgBox for Output

9. Using MsgBox for Input

10. Using VBA InputBox

11. Using Application.InputBox

3. VBA Control Statements

1. If Statements

2. If … ElseIf Statements

3. Select Case

4. For … Next Loops

5. For Each … Next Loops

6. Do … While Loops

7. Do … Until Loops

8. Creating Arrays

9. Dynamic Arrays

10. Utilising Arrays

4. Procedures and Functions

1. Sub Procedures and Module Level Variables

2. Static Variables

3. Passing Parameters

4. Creating and Calling Functions

5. Creating User-defined Functions

5. The Application Object

1. Changing and Restoring User Settings

2. Application.GetOpenFilename

03. Application.GetSaveAsFilename

4. Controlling Screen Updating

5. Suppressing Warning Messages

6. Code Recognition Clinic

1. Example 1

2. Example 2

3. Example 3

4. Example 4

5. Example 5

6. Example 6

7. Hyper-disambiguation Practice

7. Files and Workbooks

1. Targeting Workbooks Efficiently

2. Checking Whether A Workbook Is Open

3. Checking Whether Several Workbooks Are Open

4. Checking Whether A File Exists

5. Checking Whether A Folder Exists

6. Deleting Files And Folders

7. Processing All Files In Folder

8. Worksheets and Charts

1. Targeting Worksheets Efficiently

2. Copying Worksheets

3. Moving Worksheets Between Workbooks

4. Saving Worksheets As Seperate Workbooks

5. Working With The Sheets Collection

6. Creating A Standalone Chart

7. Creating An Embedded Chart

9. The Range Object

1. Copying A Range Of Cells

2. Using The Offset Property

3. The End Property

4. The Resize Property

5. Entering Formulas With VBA

6. Deleting Ranges

7. Inserting Ranges

8. Outlining Ranges

Microsoft Excel VBA Programming

£ 75 VAT inc.