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

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


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

  • I have many objects that I wish to automate both in excel and word.

    The excel objects are based on a large dataset and my need is to set up a dashboard to allow management to see problems areas within a particular work process and pinpoint exactly where the problems are arising.

    In word we have many set templates which should follow a standardised formatting directive, but the staff are constantly changing and the directive is not being followed causing additional work for the support team and delaying of the required outputs to senior management. I would like to use VBA to setup automatic formatting and data entry to speed up the process.

    I have used VBA before, but a long time ago and so I need a refresher and learn about the new features that the MS applications have created to assist me in my quest to automate and streamline these processes.

  • I’m not sure what processes I’d like to automate yet. I’m trying to get a refresher on working with VBA. Your videos and presentation style are excellent — very clear and straightforward.

  • Hi, this one’s a really good lesson to learn VBA as a beginner.
    I want the data from another excel where the data is updated on a daily basis, what i the code I should be using in order to get this thing done?

  • Hi Jon,

    I have a big spreadsheet with tons columns. My team of 10 are using it everyday. Each members has different interest in different fields (columns) so we often have to filter the table by some categories and hidden some columns.

    1. I want to create a button to clear the filter. I follow the exact steps in your video but the marco still not running. Dont’s know how to troubleshoot it.
    2. I also wonder if we can display all and sort the table by the “start date” column.
    3. I also want to create a marco that can do hiden and unhiden column and filter some categories to save my time every day.
    4. I want to create a marco to set up the print area.

    Are all possible with VBA?

    Looking forward to attend your VBA course, but hope you can help me in the mean time.

  • Hello

    I have a spreadsheet that tracks tasks. There is a reporting process that passes from one person to the next. Once they complete their process they will change the drop-down from “No” to “Yes”. In the first column, I want to show who is the current owner of the process. The macro I can vaguely see is:

    If column N says “No” then column A = column I.
    If column N says “Yes” then column A stays blank.

    Move on:

    If column Q says “No” then column A = column I.
    If column Q says “Yes” then column A stays blank.

    Move on:

    If column V says “No” then column A = column H.
    If column V says “Yes” then column A stays blank.

    And so on….

  • I have data with 30 and 40 columns in 10 sheets.
    I want to filter 1 column with one name and delete all others in all the 10 sheets