Learn How to Use Properties and Methods in Excel VBA Effectively

Understanding Objects, Properties and Methods in VBA is really important if you'd like to write your own Excel VBA code from scratch or update the VBA code you find on forums.

I cover objects and the Object library in detail inside the course. This is also a key concept. We cover this in detail as well as how to find the right object reference and the right syntax to be able to write your code.

Key Insights:
- Understanding Properties and Methods: Gain a clear understanding of what properties (what an object has) and methods (what an object does) are in the realm of Excel VBA.
- Real-World Analogies: Learn through simple, relatable examples comparing cars and shoes to Excel objects, making complex concepts easier to grasp.
- In-Depth Exploration: Discover how properties follow the object hierarchy in Excel and how methods can change these properties.
- Practical Examples: See real Excel applications of properties and methods, like changing cell values and colors or using the clear and delete methods effectively.
- Interactive Coding: Follow along with coding examples to see how to read, write, and manipulate Excel objects using VBA.
- Learning Made Easy: Don’t worry about remembering every detail! We’ll show you where to find the right properties and methods when you need them.

★★ Links to related videos: ★★

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#ExcelVBA

[_quelinian]

Thank you for this and other videos. I use Excel a lot in my job and started to learn VBA to enhance my skills. I love you, the way you explain things and your unexcited voice. It's impossible not to understand the stuff! :-)

[ckokse]

Finally, I have hope that I will crack this VBA topic. Your tutorials are great! Can't wait for your course to finally come out.

[birajamohapatra]

the way you simplifying is really awesome, you are an excellent 👍

[vijaygusain]

Finally plunged into your VBA course and I am enjoying it so far...God bless u!

[danileifer]

Thank you so much for covering theory!

[keishrich]

Leila, you presented this info well. The relatable graphics enhances it. I purchased a VBA course a couple years ago, but I' thinking about getting yours as well. Thank you!

[samseuropejourneys]

Spend two months to find a best tutor finally found it ....

[vida]

You are great teacher, Leila - nice analogies and as always good explanation

[karolinagrygiel]

Great channel, thank you for sharing and the delivery is really good. Thank you for putting time and effort

[kabootty]

Excellent and clear tutorial. Thanks & wish you all the best. Waiting for the next session.

[nerenlakhraj]

Awesome tutorials, very well explained and presented ... keep up the great work you doing

[ismailismaili]

thank you so much for the explanation Ms. Leila.

[gopalakrishnarao]

Very impressive, inspiring, interesting, realistic, lucid and Candid. Thanks a lot Madam. Good & Great Job indeed.

[sasavienne]

You are amazing Leila. An excellent way of explaining properties and methods. Thanks

[excel-finanzas-pakal]

thank you for sharing, excellent explanation, i feel motivated to learn VBA. Greeting from México!!!

[rockguitarist]

Registered for the course discount. Can’t wait to learn more from you on VBA.

[jennydrumm]

OMG! You are a genius of a teacher!
I've been working with macros for several years but it always takes me FOREVER to finish creating one, because I've had the worst time getting my brain wrapped around the concept of Properties, Methods and Cell/Range/Row/Column reference syntax. Basically, I just keep poking around and making "Row" say "Rows" or "Cells" say Cell"... stuff like that, until the code finally works! Alternatively, I'll go to a couple of message boards I like and pose my problem and someone tells me what I'm doing wrong. I really hate doing that, though, because it makes me feel stupid.
So, anyway, I figured it would help to start with your "for beginners" video, since I never really "got" the basics. I've also just watched your video on cell (etc) referencing and loved it as well. I'm probably going to watch each of them a couple more times so I can try to get it firmly in my head.
You make things so clear and understandable and the fact that you do it along with telling about it is perfect for a visual learner like me. Plus, you speak slowly and clearly enough that I can actually absorb the information.
Sorry for writing a book here, but I'm just so happy! (Excel is my favorite toy, LOL!)
Did I mention you're brilliant? Thank you, thank you!

[cliftonsett]

Great content, informative and to the point. Thank you

[vba-jzue]

Hi Leila, I need some help,
How automatic user id (window) show once data in a excel sheet cell enter by user? with vba or without vba.

[marcellokassa]

A wonderful video... Thank you very much indeed!