VBA Training Series BONUS: How to Reference Common Objects in Excel with VBA

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!

26 comments

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

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

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

  • 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

  • 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

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

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

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

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

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

      https://msdn.microsoft.com/en-us/library/office/ff194068.aspx

      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.

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

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

  • 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

    Range(“A3”).Offset(1Sht).Value=Worksheets(1Sht).Name

    Next 1Sht

    What is their function.

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

  • 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