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.

Jon Acampora Circle MVP Profile 2019

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!

  • Hi Mr. Jon, how we can write macro to refresh all Pivot tables if we have more source data sheets and pivot tables in one workbook.

  • Although English is my second language, but I can understand your lesson easily.
    You have explained everything in details so I fully got it!
    Thank you very much, Jon!

  • I want to acquire some skills that help me to automate reading data files from analytical instruments and process the contents.

  • the process i am trying to automate in excel is , tracking time in a workshop environment so that multiple users can track there time in one place. The collected data can then be shared with the office personal who collects the time sheets and inputs the data to the proper job costing

  • Hi Jon, Thank you for these fantastic videos. Unfortunately I just can get the first one. Did not received any link for video 2 and 3

  • amazing explanation with brave visualization,, very clear and easy to understand ,, I have a question ,, what is the code to copy paste value cell to another cell base on other cell value,, lets say if A1=”close” then copy value cell B1 to cell C1 without any button press, thank you

  • Is it possible to develop a data entry program in Excel. I want to create a form to capture blood work results and store them into SQL server. Please advise. If you have any samples can you please show me?

  • This is a great start to learning.

    Need to clear contents of multiple columns or cells based on content of other cells. Will also need to delete rows based on cell content.

  • I have a live “database” file that is automatically being updated by our test machine as it completes testing. However, it can only populate one test per row, with “Material” as one of the columns. I want to have an excel file that I can open up that will automatically search for a specific material then take the test results for that material and put into sequential columns.

  • Jon, thanks for all the great resources you provide! I’m a small business owner and my product is heavily based around Excel. My automation goals would include providing a “watered-down” version of the template spreadsheet we use internally so that we can provide it to clients as a deliverable without making their heads spin. Essentially, to use VBA to copy and paste certain parts of the template w/ formulas included and certain parts as values only. Also, in general, to make data visualization improvements on the user end i.e. creation of a dashboard with picot tables, graphs, slicers, etc.

  • >