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,511 comments

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

  • Video one was very helpful. Thank you.

    I am attempting to write a VBA macro to copy one column of cells to another within the same worksheet as values. The difficult part is that I want to make the offset variable based on a cell value. We create monthly SOVs for pay applications. I am trying to assist in rolling the spreadsheet forward every month.

  • there are multiple reports that I am creating daily using excel and SNOW. how do I automate them so that I can save my time.

    The DATA is extracted from SNOW and then is edited in excel.

  • Thanks Jon, Video 1 was very helpful. I am a intermediate Excel user and I am at the stage were I need to get familiar with VBA and this has given me the motivation to learn more.

  • This series should be very useful for me to learn from a step-by-step process on what is VBA, how to use it and the skills in writing commands. Thank you for the excellent tutorials.

    May i know why i can’t proceed to video 1 after typing my email? And i didn’t receive email as well?

    Thanks.

  • Great video. Simplicity of delivery caught me there. I cant wait to see parts 2 and 3. Thanks in advance for making them available.

  • I’m looking to make clickable references in the first column on a report that generates a new worksheet like you would in html.
    It would make order viewing easy at my workplace and you could just click in and see what order without using a huge query that takes forever to run.

  • Hi Thanks for the video. I’m searching for generating a product registry from another sheet entries. I have already done to fetch the single entries like invoice numbers, customer names etc but could not fetch each products line items. It’s fetching only the last line item only leaving other lines as blank. Could you help me on this or anything similar codes / videos available

  • Hi there and thank you so much. I am trying to help a lady at work who creates a Meal Planner for 7 days a week and does it all manually. I have some parts completed but my lack of VBA and programming knowledge is letting me down.

    I can send my spreadsheet but I am sure you have more important things to do.

    Regards,

    Les

  • Hi. I keep getting an error called OLE error when I am working on few heavy excel sheets. Would you to be kind to share what could be the solution for this issue?

    Thanks,
    Shweta

  • The video was very useful and promising. I hope to work on making my own macros to help expedite my calculations. Thanks

  • Hi,
    i have calculation table wherein i enter the data and run calculations. Whenever new data is entered and calculations run, the old results gets overwritten. I wanted to transfer that results of every run to some other cell/worksheet and form a table of the results.

  • Thank you Jon. The first video was very promising. I have watched other videos and read books on the subject at a very rudimentary level so far but your explanations were very clear and hopefully will continue to be so in the other videos too! thanks again. I hope eventually to be able to write codes that will copy certain information from one sheet in a different layout (say from rows to columns) into another sheet to summarise and collate the data and perform some actions on them. I don’t know how feasible this will be for me but we’ll see.
    Thanks.

  • 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.