VBA Macros for Excel – an introduction

.

37

LESSONS

ALL

SKILL LEVEL

3:37 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

Microsoft Excel is an extremely powerful tool, yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and so on, you can automate it and add buttons and forms to include interactive features.

This course covers the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products). Once you have finished the course, you will be well on your way to developing your own macros to solve your own problems, as well as being able to apply the knowledge in Word and PowerPoint.

.

WHO IS THE COURSE FOR?

This course is for you if you want to automate Excel and provide a better user interaction.

No prior knowledge of VBA or another programming language is required, but any existing knowledge will help.

It will be assumed that you have some understanding of Excel, with the ability to use basic formulas and colour cells.

This course is not for you if you are already confident in using VBA and want to learn more advanced techniques.

.

LEARNING PATH

RECORDING YOUR FIRST MACRO

  • The developer tab.
  • My first macro.
  • Relative references.
  • The editing environment.
  • Hello world!
  • Saving and opening our spreadsheet.
  • Security.
  • Self-certification.

VARIABLES

  • Introducing variables.
  • Scope.
  • Breakpoints, the Immediate Window, and Watches.
  • String operators.
  • Declaring types of variables.
  • Avoiding typos.

THE EXCEL OBJECT MODEL

  • Interacting with the Excel spreadsheet.
  • Introducing objects.
  • Introducing the Object Model.
  • Default objects and default properties.

LOOPS AND IF STATEMENTS

  • For…Next Loops
  • InputBox
  • IsNumeric and If…Then
  • Is…Else…End If
  • Val()
  • Do While…Loop
  • Other types of loop
  • Selection
  • Set
  • For Each…Next Loop

.

REVIEWS

“Great course! I can tell he is a subject expert. Examples are clear, practical and starting with the simplest.” Jose

“This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in-depth knowledge.” Daniel

“Very clear demonstration and explanations. Materials covered are very useful.” Jean

.

READY TO START?