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

Userforms:
The Exports Sheets App

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

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!​

1,493 comments

Your email address will not be published. Required fields are marked *

  • Hi Jon –

    I would like to copy and paste a series or range of numbers from one workbook into another. Each one of the numbers from the first workbook to be pasted into 27 rows of the other and then repeated with the next number down in the range from the first workbook into the next 27 rows in the second (basically cell B2:B28 then B29:B56 and so on. I have 500 numbers in the first to be copied into 13,500 rows of the second. It is gobbling up my time to copy and paste all of these! Help!

  • I am trying to copy and paste some rows and columns from one worksheet to another. It is for sales data so the titles of each will stay the same it will only then need me to input the data for each one every week.

  • I had no experience with macro in excel and your video’s are helping me to understand what is happening.

  • I have a report (of varying length), and I need to create a tab for each item on the report, add a standard template to each tab, and fill it in using the data from the report to complete it.