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:
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.
Click Here to Learn More About the Course
Please leave a comment below with any questions. Thanks!
you explain everything very clearly.
Thanks Raja! 🙂
I just hoped you would come out with a physical book. Have learned all of my skills by a book…not a video.
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
Thanks for putting this together. Better than any book
Thanks Xiaoyan! I really appreciate that. 🙂
Thank you Jon,
For me,Very useful videos.But I want to understand better where to put the (.,””,(),[]) in the code.
Thanks Petrit! I’m not sure I understand your question.
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.
Wow,very nice.
Thank you
Thank you Sushil! 🙂
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.
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.
Nicely done, Jon. I sure could have used something that straightforward back in the early days of my journey with VBA! Excellent material.
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.
Thanks Sir..
Thank you very much Jon! That it’s helping me a lot.
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!
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
thank you Jon for making my job easier 🙂
Thank you very much Jon!
it’s helping me a lot.
You are great………..
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
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.
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.