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

Click Here to Leave a Comment Below 1231 comments
Bobby - July 20, 2017

Nicely done

Reply
Neha - July 20, 2017

To consolidate weekly case tracker of my team.

Reply
Omprakash - July 18, 2017

Excellent tutorial, very easy to understand.
Thank you for your efforts.
Have a great day!

Reply
Marlena - July 17, 2017

Hello,
This is a great video.
I am very new to VBA and found other courses intimidating.
Your training really works for me and as an assistant accountant I would like to automate many projects like product mix reports, budgets, forecasts, auditing files etc.
Looking forward to more lessons!

Reply
Hugh - July 12, 2017

I need to copy a range of numbers to blank rows below the last row of the range I am copying. The number of rows may change. The number of columns do not. I would like to paste the copy below the original range with a blank line in between them. There are totals I would like to copy for each column except the first two.

I did macros years ago, but got away from them when it went to VBA. How do I define the start of the range to copy from (top left to bottom right), then define the top left of the target? Do you have a sample I can alter? The format is below. Thanks for your help, Hugh

11-Jul 100 20 120 10 15 5 2 65
11-Jul 100 20 120 10 15 5 2 65
11-Jul 100 20 120 10 15 5 2 65
11-Jul 100 20 120 10 15 5 2 65
700 140 840 70 105 35 14 455

Reply
Meera - July 10, 2017

I have X value in sheet1. Need to check X value in sheet2. If found, it should pick up the data (complete Rows & Cols) till it founds blank, from sheet2 and paste in sheet3. Can you please advice simple, quick macro for this.

Reply
Ben - July 2, 2017

I use Excel to calculate the allocation of various types of common areas to basic measurements of spaces. I then prepare small tables of four cells for each space plus summary tables. I then copy and special paste them to Autocad. That way I avoid transcription errors and get dynamic updates.

What can happen, though, is that when I do make a change, some tables update, but others do not. To detect the tables that do not update, I use background color for the legend of each cell and change it every time I change the calculation. I manually change all the tables every time.

It works, but if I could automate this process, I would be even happier.

Reply
Mike - June 29, 2017

Thanks Jon. ths is a nice introductory video. Right now I’m simply looking to automate Copying a range of values (held in a column) and pasting them onto the end of another Column and then repeating the action accross a specified number of columns in a workbook.

Reply
Sam - June 29, 2017

The object Hierarchy explanation really helped me understand. The macro I was currently working on was really giving problem. But the Hierarchy concept really helped and I got the bug fixed.

Reply
Dharmendra - June 28, 2017

it is very useful learning. Thank you for guiding us in such a nice way.

Reply
Naval - June 26, 2017

This is the easiest way to learn VBA

Reply
Ariska - June 24, 2017

None at the moment. Just want to develop my skills

Reply
cecilio - June 23, 2017

Excellent training Jon!

Reply

Leave a Reply: