Macros & VBA Training Series BONUS VIDEOS:

How to Reference Common Objects in Excel with VBA

Double-click the video to view in full screen HD.

Download the file used in this video:

My First Macro - Reference Common Objects.xlsm (105.6 KB)

The videos above are from Module 1 of The VBA Pro Course.  This course is a step-by-step learning system that will take you from beginner to VBA expert.  Click the link below to learn more and enroll in the course.

VBA Pro Course Beginner to Pro Banner 480

Click Here to Learn More About the Course


Please leave a comment below with any questions.  Thanks!

Click Here to Leave a Comment Below 25 comments
Edwin R. Seils - September 17, 2018

Thank you so much for this link, I am sure I will be referring to this on many occasions while programming in VBA.
As I wrote earlier, regarding my disability status, this information will greatly assist me in furthering my understanding of Excel and VBA. Unfortunately, I will be unable to partake of your FREE Webinar on Tuesday, 18 Sept., as I have a Dr’s appointment at the time it will be airing. Look forward to future offerings.

Susan - September 17, 2018

Hi Jon!
I’m a newbie when it comes to VBA. I am fascinated in how it works and want to learn as much as I can. I use Excel daily and it is my favorite application. I’m hoping that I can help my boss with setting up budget worksheets using VBA. Thank you for your videos. I’m a hands on learner and these videos help me understand the concept of VBA and what it can do.

Umer - July 25, 2018

Hey Jon you are awesome please keep continue like this.Some times i missed you videos later i came to know all your mails had gone to junk.including the last video lecture of VBA Macros & now i have to mark all of them is not a spam mail :P…

Kind Regards

Randhir - January 29, 2018

Thank you very much Jon!
it’s helping me a lot.
You are great………..

Yusni - January 26, 2018

thank you Jon for making my job easier 🙂

Myint Zaw - December 23, 2017

Dear Jon Acampora

You are very smart teacher for excel and I have a plan to study from you. At the moment, I’m trying to get my master degree.

Best Regards,
Myint Zaw

Chin Hooi - September 12, 2017

Wonderful, well explain cos this the most important step because there’s alot of videos with codes but I just don’t understand.
It’s important to have excise worksheet to practices then you can remember better.

Maria - September 8, 2017

Thank you very much Jon! That it’s helping me a lot.

Muhammad Amir - July 15, 2017

Thanks Sir..

Peter Taggart - June 30, 2017

Thanks Jon…..This is really good stuff that can make the work day much easier. Once again..thanks for all that you share with us and professional manner that it is presented. The learning process is much quicker and the material is a lot easier to understand.

rab - June 15, 2017

Nicely done, Jon. I sure could have used something that straightforward back in the early days of my journey with VBA! Excellent material.

bromberg - January 28, 2017

With all the 1,000s(?) of objects, methods, and properties that Excel VBA offers, how do you ever know which ones to use for a specific task, and where are they located and documented?

    Jon Acampora - January 30, 2017

    Hi Bromberg,

    Great question!

    You will learn more and more about the object model as you start writing macros and automating projects. It’s very similar to all the functions in Excel. We don’t use them all on an everyday basis, but learn more as challenges arise.

    The VB Editor does have an Object Browser where you can see all the objects, properties, methods, events, in each object library. You can press F2 on the keyboard to open the object browser in the VB Editor.

    The Object Browser is pretty difficult to navigate in my opinion, but everything is there.

    Another way to navigate the object model is on the MSDN help pages. Here is the top level page for the Excel object model.

    On the left side you will see a list of objects, and you can start drilling in from there. You will continue to see the objects properties and methods on the left side as you drill down.

    I hope that helps get you started.

Wayne Lawrence Thomas - January 26, 2017

Hello, Mr. Acampora I really fascinated with all your videos on VBA you are a Master in this area all that you have showing until now is remarkable it has helped me a lot to understand a lot of the excel VBA. here is a question I have for you ¿is there a way that records could be saved simultaneously into two workbooks with VBA?

thanks in advised for any tips you could come up with
have a marvelous day

Bless you.

    Jon Acampora - February 4, 2017

    Thank you for the nice feedback Wayne! I’m happy to hear the videos and articles have helped.

    Yes, you can use a macro to copy data to multiple workbooks. You can even use a worksheet event to automatically copy the data when it is input in the source file. I hope that helps.

Sushil - October 25, 2016

Wow,very nice.
Thank you

Petrit Kanina - July 19, 2016

Thank you Jon, for your answer,
but I am interested to know when or where put the punctuation marks as (point,comma,bracket etc)

for example :

For 1Sht=1 to 1Count


Next 1Sht

What is their function.

Petrit Kanina - July 14, 2016

Thank you Jon,
For me,Very useful videos.But I want to understand better where to put the (.,””,(),[]) in the code.

    Jon Acampora - July 18, 2016

    Thanks Petrit! I’m not sure I understand your question.

Xiaoyan - July 14, 2016

Thanks for putting this together. Better than any book

    Jon Acampora - July 18, 2016

    Thanks Xiaoyan! I really appreciate that. 🙂

Andre - July 14, 2016

Thanks for the content! As an intern these videos are very helpful. I would appreciate it if you could emailed more videos regarding excel and VBA. It looks like I am denied access to video links not from my email.

Great resource! Thanks for your time and effort, Jon

RAJA - October 23, 2015

you explain everything very clearly.


Leave a Reply: