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 1398 comments
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: