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 1411 comments
Anthony Sisay - July 12, 2018

Thanks. The presentation was impactful.

Reply
Siegfried - July 11, 2018

We always get data from a database, with a lot of unnecessary information, so i want to prepare this data in a more readable form

Reply
Patrick - July 10, 2018

This is exactly what I needed. I pick stuff up pretty quick, but I really needed someone to just break down the foundation of what’s going on here. Once I understand the language of something, I can typically run with it. I am in the lending industry, and I use an Excel Workbook that I’ve been dialing in for a long time. I use it to do all of my analysis when qualifying a borrower. Getting some Macro’s involved will really get the job done the way it should be. Most grateful! 🙂

Reply
Karl - July 8, 2018

As an Consultant, I have a lot of things to manage and keep track of. Loads and loads of data.

What I need is a Content Management system, but all I have is Excel. It seems as if VBA will help me get something created until which time a Learning Content Management System (LCMS) is procured.

I have some VBA experience, but as with anything you do not use daily, I’m pleased with the first video. Very clean. You articulate well, have a nice pace, and display what is relevant. I respect that very much.

Thanks.

Reply
Gavin - July 7, 2018

Hi Jon,

Great tutorial, thanks…looking forward to the next.

G.

Reply
Jessie - July 6, 2018

Really helpful step by step on the hows and whys that is useful for beginners and practical when applying in the workplace. Thank you!

Reply
Hassan Jatta - July 2, 2018

Thanks for the lecture. Very help.

I want a VBA code to post from a cash book to ledger accounts. Basically want to use excel to maintain a simple set of account.

Reply
Mohammed - June 30, 2018

I’m Glad to be one of your student.

Reply
Shawn Kelly - June 27, 2018

Hi John, I always like an instructor using visualization techniques and analogies.
My intention is to create a list of dropdown questions for a service call which will identify one or two individuals qualified for the call using rows for the individuals and many, many columns of details pointing to the dropdown questions. Hopefully this will be a fun project for me and I learn something new. I do have some abilities but am working from days long gone writing in Motorola processors and GW Basic code.

Reply
Harold Bell - June 25, 2018

Hi Jon.
When entering data in cells A1 through A10 after pressing return I would like the cursor to jump to cell A2 so that I could continue entering new data.
Your teaching method is good. Thanks for the help…HB

Reply
Ian GORMLIE - June 23, 2018

I would like you to demonstrate a macro that dynamically identifies the populated data area in a worksheet and then copies and pastes the data from that area to the bottom of the data in another worksheet. ie combining the 2 sets of data from 2 separate worksheets into 1 worksheet where the size of the data in each sheet must first be identified.

Reply
Ian GORMLIE - June 23, 2018

Thanks for your introductory videos. I found them very helpful and easy to understand.

Reply
lowell - June 22, 2018

Thank you for sharing!

Reply
Ali Obeid - June 16, 2018

Hello there;
my question is how to write a macro that search for a specific word or verb in one column and will copy this particular word into another column of the same row and in the same worksheet? thank you

Reply
karthikeyan - June 16, 2018

Video 1 is awesome, as a beginner its very easy for me to catch up on your training, I appreciate your way of teaching from the basic with all the concepts explained clearly. Thank you for making us feel VBA is easy for learning as a beginner. kindly send me the link for the consecutive videos.

Reply
Prabhakar - June 12, 2018

Good and detailed one

Reply
Merali - June 5, 2018

Excellent step by step instructions on writing macros using VBA code. Thank you for sharing.

Reply
KAMRAN - June 3, 2018

I like the way you go step by step.
It helps for better understanding of the topics

very good explanation and example

Reply
linda mckenzie - May 24, 2018

Enjoyed the love and kindness that flows effortless when you give your talent back to others. You are being blessed by
being a blessing to others. You are obeying the word by being a giver of your knowledge. It is better to give than receive.

Reply
Mark Justice - May 22, 2018

Hi Jon,

This was my very first introduction to VBA, I had seen the screen before and always thought it was beyond me. I really enjoyed the way you explained everything and look forward to the next video. Amazing that there are people like you out there willing to give your time to help others, thanks so much.

M

Reply
Charles - May 19, 2018

I learned a lot from this video

Reply
Riju - May 18, 2018

Easy to understand with your videos.

Reply
Inessa - May 15, 2018

Great video!

Reply
Terry - May 15, 2018

GREAT JOB!!!!!!!!!!!!!!!!

Reply
Terry V. Williams - May 11, 2018

Hi,

I would like to learn advance macros using VBA language. Currently, I have
executed macros on an intermediate level; but I am a beginner in writing the
VBA language. I do have programming experience using COBOL II.

Reply
Kmer For Life - May 10, 2018

very good explanation and examples. I like the way you go step by step. It helps for better comprehension of the topics. Great job -)

Reply
Donald - May 7, 2018

I am Trying to write a nutritional database in Excel 2007. I wish to be able to copy and paste say recipes. Therefore I would have to enter all the ingredients quantities and calories ect copy this to another place or to another worksheet then delete the excising data.

Reply
Joyce - May 4, 2018

Great video!!!!

Reply
Giuliano - May 4, 2018

Hi Jon,

I will have to read somebody else’s VBA code and enter comments for the next technical person that works on it.

It’s 10,000 lines of code and I only wrote macros by recording plus entering and modifying code found on line.

It sounds daunting so I better learn as much as I can…and quickly 😉

G

Reply

Leave a Reply: