VBA Training Series – How to Write Your First Macro (Part 1 of 3)

Macros & VBA Training Series Part 1:

Writing Your First Macro & The Excel Object Model

Double-click video to view in Full Screen HD.

Download the file used in this video:

My First Macro.xslm (93.0 KB)

Macros & VBA Training Series

Enroll for FREE

The video above is the first in a 3-part training series. Can I send you the next two videos?

Please click the link below to enroll in the free training. I will send you video #2 in just a few days.

Video 1

Intro to VBA:
Writing Your First Macro

Video 2

Automating Tasks:
The Summary Report

Video 3

The Exports Sheets App

Please click the big green button above to register for the free training series.

Jon Acampora Circle MVP Profile 2019

About Me

Welcome to Excel Campus!  I am excited you are here!

My name is Jon Acampora and my goal is to help you learn Excel to save time with your job and advance in your career.  I've been an avid Excel user and VBA developer for 10+ years.  I am also a Microsoft MVP.  When I'm not looking at spreadsheets, I get outdoors and surf. 🙂

What Process Do You Want To Automate in Excel?

Please leave a comment below with your answer, and any questions.  Thanks!

  • Hi Mr. Jon, how we can write macro to refresh all Pivot tables if we have more source data sheets and pivot tables in one workbook.

  • Although English is my second language, but I can understand your lesson easily.
    You have explained everything in details so I fully got it!
    Thank you very much, Jon!

  • I want to acquire some skills that help me to automate reading data files from analytical instruments and process the contents.

  • the process i am trying to automate in excel is , tracking time in a workshop environment so that multiple users can track there time in one place. The collected data can then be shared with the office personal who collects the time sheets and inputs the data to the proper job costing

  • Hi Jon, Thank you for these fantastic videos. Unfortunately I just can get the first one. Did not received any link for video 2 and 3

  • amazing explanation with brave visualization,, very clear and easy to understand ,, I have a question ,, what is the code to copy paste value cell to another cell base on other cell value,, lets say if A1=”close” then copy value cell B1 to cell C1 without any button press, thank you

  • Is it possible to develop a data entry program in Excel. I want to create a form to capture blood work results and store them into SQL server. Please advise. If you have any samples can you please show me?

  • >