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 17 comments
Muhammad Amir - July 15, 2017

Thanks Sir..

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

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

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

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

    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.

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

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

    Reply
Sushil - October 25, 2016

Wow,very nice.
Thank you

Reply
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

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

Next 1Sht

What is their function.

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

Reply
Xiaoyan - July 14, 2016

Thanks for putting this together. Better than any book

Reply
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

Reply
RAJA - October 23, 2015

you explain everything very clearly.

Reply

Leave a Reply: