Learn How to Use Properties and Methods in Excel VBA Effectively
HTML-код
- Опубликовано: 4 апр 2018
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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.
This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here 👉 www.xelplus.com/course/excel-...
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.
Written Article: www.xelplus.com/vba-object-pr...
★★ Links to related videos: ★★
Learn about Visual Basic Editor: • Excel VBA tutorial for...
Recording macros: • Excel VBA: Copy Data f...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
Get access to the full course here 👉 www.xelplus.com/course/excel-vba-excel-macros/
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! :-)
Spend two months to find a best tutor finally found it ....
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.
Thanks! Glad you like the tutorials. Yes - in 2 weeks the course should be finally out :)
Finally plunged into your VBA course and I am enjoying it so far...God bless u!
That's great Vijay. Thanks for your support.
the way you simplifying is really awesome, you are an excellent trainer..... 👍
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!
You're welcome. I'm glad you find the presentation is easy to follow. Thank you for your support. If you do decide to get the course, I'll be interested in your feedback.
You are amazing Leila. An excellent way of explaining properties and methods. Thanks
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!
Thank you for your comment Jenny! Your comment made my day :) I'm glad you find the videos easy to follow. I can fully relate. It took me a while to "get" VBA. Like you, I always managed to get my files working but things didn't really click, until I really took time to understand the fundamentals. I'm happy you find value in these tutorials. Thank you for your support :)
Oh, I meant to also say that (as ExcellIsFun already said) the analogies are awesome! That's one of the key things that help me understand things. Wonderful!
Very useful. Thank you!
You are great teacher, Leila - nice analogies and as always good explanation
Thank you Vida! I'm happy to hear it's easy to follow....
Thank you so much for covering theory!
thank you so much for the explanation Ms. Leila.
You're very welcome Ismail.
Very impressive, inspiring, interesting, realistic, lucid and Candid. Thanks a lot Madam. Good & Great Job indeed.
Thank you very much Gopala. I'm glad you like it and thank you for your support :)
Excellent and clear tutorial. Thanks & wish you all the best. Waiting for the next session.
You're very welcome! Thank you for your support - yes, next week we move on - this time with hands on VBA work :)
Great channel, thank you for sharing and the delivery is really good. Thank you for putting time and effort
You're very welcome Karolina.
At last.... waiting is over....love your video..as always
Thank you! As always... thanks for your support :)
Registered for the course discount. Can’t wait to learn more from you on VBA.
Thanks for your support. I'm looking forward to your feedback.
Awesome tutorials, very well explained and presented ... keep up the great work you doing
Thank you! Glad you like them. Will do my best :)
thank you for sharing, excellent explanation, i feel motivated to learn VBA. Greeting from México!!!
That's great to hear :)
Good way to explain the content.
Easy to understand thx
Great content, informative and to the point. Thank you
You're very welcome Clifton.
Brilliant explanation, very easy to follow and to click into place
Thank you Darren. Glad you find the explanation easy to follow.
perfect 💪🏻💪🏻 Thanks
A wonderful video... Thank you very much indeed!
You're very welcome Marcel :)
thanks Leila for uploading all these great lessons.the way you teach VBA it looks so simple but I still cannot write a simple code.
Don't give up and keep practicing!
You are the best teacher I have ever seen!
Thank you for the kind words!
@@LeilaGharani Can you please solve this for me and for all of your followers?
Say, I have 100 numbers in column A of Sheet1. I want to extract first 10 numbers from Sheet1 to column A of Sheet2, second 10 numbers from Sheet1 to column B of Sheet2........... to column J of Sheet2 the last 10 numbers from Sheet1. How can I do it using ExcelVBA?
So nice .
Thanks for you.
You're welcome.
Didn't know you had VBA in you :) You give very clear and easy explanations. I'm looking forward to the series.
Hi Sal. Glad you like the VBA videos so far.
absolutely perfect / amazing video for beginners i have ever seen... perfect even for girls :). thank you for such great videos which learn girls to easily understand so hard begginings of vba :)
:) I'm really glad you liked it!
Thanks
You're welcome.
Nice !!! 👏👏👏
Thanks for the video Ma'am...
You're very welcome Mohit.
Great video as usual Leila, question when is the VBA course to be released? I am waiting for it.
Very clear to grasp. Keep it up|
I'm glad to hear it's clear. Thanks for your comment & support!
Thanking you madam, very useful ,
You're very welcome.
Again thanks a lot mam for this video
You're very welcome Sumit.
Thanks for the insightful video. I've enrolled in the 5 Udemy courses in the description. I'll start them as soon as I finish another course I'm taking.
Oh Wow! Thank you for your support. I hope you find a lot of value in them. Looking forward to your feedback. This week I actually enrolled in 3 Udemy courses myself - need to find some time to go through them :)
Nice presentation ):
Thank you Hamidur. Glad you like the presentation. This time on PowerPoint instead of Excel :)
Hi Lella, your videos are amazing. I learnt many new ways of representions and many properties, methods as well. Thanks for it.
I have a doubt, I am using Application. Celldragand drop=false
But when i do this the option is not working in all other workbooks i open, but what to make celldraganddrop as false in only one workbook and true in all other. Can you help out with ot
Ilove u soo much
Thanks Mam Nice Video
You're very welcome. Glad you like it Khalid.
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.
Please do more VBA tutorials this year. 2021. We love u too much
Agreed.
thanks thanks thanks
Thanks god
Welcome back
Amazing as always
I do like this day because of your videos
Continue and we will continue
Thank u
Thanks :) it's my favorite day of the week too! I'm glad you like the video. Thanks for watching.
As usual, beautifully explained.
When will you start the VBA course?
Thank you. In about two weeks :)
Please make a video on sendkeys bug (turns NumLock or and caps lock on off) I'm new to vba, so i created a simple code to paste the data as values to my designated cells using alt 6. Thanks.
HI Leila,
I agree with Mike,your course is going to be gold. I know our course is going to shine!!!!
Interesting that VBA has elements of a language in its description. Like the objects could be nouns, properties an adjective and methods as a verb (hopefully I got those write). Read/write capabilities? Sounds like language, don't you agree?
Thank you for the time breaking down the objects, properties and methods. Relating that to a shoe really hits close to home, doesn't it?
Michael
Thanks Michael for your trust and support. I remember you referring to them as elements of a language. I like that too - but I always go back to the shoe :) . It's currently nearly 3 in the morning here and I'm doing the final touches on the vba course :)
I do like your heel analog as well. It is very visual and easy to comprehend. I use the language analogy only because VBA is based upon a computer language and I find it easier sometimes to identify objects, properties and methods to part of speech and how it relates to the thought process behind the computer language.
thanks leila. I am following all the coming videos. Although I must say that I am more of a formula person and that's Mike's fault :). However This is becoming interesting too.
I understand :) thanks a lot for following though. Next week, we'll actually be writing to cells by typing in the VBA code ourselves. There is also a VBA with formulas video coming up, where we create our own sum formula that sums by cell color. That might be something you'll like :)
"thanks a lot for following though" People like me should thank you for making the videos for us to follow. Summing by cell color: Someone from India sent me the code and I pasted it into a worksheet at my workplace, but I would love to learn how its done. I can't wait to follow this through. Thanks Leila :)
Hi Mam, this is Siva Kumar
I will follow your tutorials. This video is good in vba. I have a plan to buy your tutorial unlock vba and excel macros from udemy. Those videos can be downloadable for long use n comfortable learning.
Hi Siva - I just saw this question. You get lifetime access to the tutorials - on PC, you can watch them online (excel and pdf files are of course downloadable), but you can download the videos for offline viewing on smartphone and tablets....
Really well explained.
Like many others, I'm looking forward to your course this month. Is there an exact date it will be released?
Thank you Andrew. I'm currently re-editing a few sections (the course seems to have reached 20 hours! of content). It should be ready in 1.5 weeks - it then depends how long the Udemy review system takes - generally 2-4 business days...
That's great, thanks.
Leila,
I know this question is off topic. But, do you have videos on Dictionaries or Collections? I would really enjoy it.
I can recommend these videos for collections: ruclips.net/video/tg7Vrlxh_RQ/видео.html&ab_channel=ExcelMacroMastery. The same channel also has some really nice videos for dictionaries
I have watched many of your instructive videos and find them very informative. Could you please guide me in : How to Control VBA Editor? For example somehow my properties window used to appear floating or under the Projects Explorer. Now is not. Can you Please Pleas Help?
There could be many reasons. It's difficult to learn VBA with isolated videos. Trust me, I've been there. Get a good online course for Excel VBA to cover the basics.
I am waiting for your VBA Course video.
Next RUclips VBA video will be on Thursday --- the course should hopefully be out sometime next week.
Welcome back!!! with another episode on VBA. I am learning VBA by watching such teacher's lectures, like you, over the web. i highly admire yor skills and way of teaching. God bless you.
I am preparing a user form and using MS Excel 2016. When I am inputting a date in a text box and saving the data with other information of other text boxes in the excel sheet, I am having the date format different. I need the date format as, dd/mm/yyyy, but the date entered as 05/03/2018 (dd/mm/yyyy) is appearing as 03/05/2018 but if the day digits are entered above 12, i.e. day number is 12 or 13, 14 and so on....the date is appearing in the cell correctly, (15/03/2018). What will be the VBA code to enter the date in the text box and get it in the excel sheet as date format? note the system date format is also as dd/mm/yyyy. I will highly appreciate if you can send the code to my email zulfiqarhamdani@yahoo.com. Thanks.
Hi - glad you like the video. If the regional settings are dd/mm/yyyy, then this would mean if you input a date directly in Excel, it shows as dd/mm/yyyy - right? are you formatting the date in VB as format(date,"dd/mm/YYYY") as well? Inputting dates in text boxes directly can be a little problematic...
Yes, the regional settings are dd/mm/yyyy. Also, I am formatting the date in VB as format(date,"dd/mm/YYYY") as well.
Thanks Mam
Can we stop vba code @ particular date. Example it should not work after one month. Pls help
I have a form with objects calling macros. I can't find a way to protect the sheet and have the macros work. No matter what I do, when I protect it, Macros attached objects stop working. Is there a way? Or do I have to not use objects and maybe change them to command buttons? How do I call the macros from the command buttons?.. You are great!
Objects Properties and methods.
Hi Leila, Thanks for your videos. Can you please explain what does the code Sheet1.Copy After:=Sheet3 mean and Sheet1.Copy , Sheet2 mean? I know they mean the same thing but can you please dissect it?
just different syntax. they both copy sheet1 and paste either after sheet3 or sheet2
Text values in value field gets converted to number.. But i want it to remain as text... I have recorded it by adding data model and using ConcateneX but this doesn't work for other sheets.
Could u please make a video to add datamodel and give text in pivot table value filed.
Madam how can i print a hidden sheet from so many hidden sheet please help in this.
Hello everyone! New to VBA and was hoping you could help me put. I am trying to hide rows (all the sam rows) in multiple sheets. Is there a quick vba that you can think off? Current I have DIM R1 as string, R2 as string..R1 = range("AC2"), R2 = range ("AD2")...rows(R1 & ":" &R2) .entirerow.hidden = true...there are about 30 rows i need to hide and about 11 sheets, so you can imagine with the script I currently have, how long it is...im sure there is a more advanced and shorter way to write this..please help!
Hi , on the course do you get any real-live assistance if you need clarification ?
No, but you can post a question in the comments and we will get back to you.
Hi I am getting error 438 object does not support this property or method while using getElementByName () metthod in my VBA macro. Please help in fixing this.
6:00 Another method of a shoe is tying the shoelaces.
I want to learn advance Excel and VBA full course please help me
Hi Leila,
I am subbarao from I am from India, Bangalore city I want to learn advance Excel and VBA course your vedios or e- book is available in Online?
Please help me
When can we have your course on Udemy
It should be live in about 2 weeks.
@@LeilaGharani Thanks a lot
How to learn vba code as a beginner. Plse give some tips
I recommend taking a structured course.
Where is the vba code examples to create properties & methods?
Hi
Good noon
Hope you are fine
I asked you one question by comments
Please help me to out that problem
(If you get little free time)
And thank for ur videos.
I will look in the evening once I get a chance....
Can you send me pdf or word to learn vba ????
Вот, отличное объяснение. Жаль не на русском
you are an object... of desire
actually, you are just a shit..
Cutie leila..
I'm lost
You are very beautiful
Great video as usual Leila, question when is the VBA course to be released? I am waiting for it.
Hi Frank. Glad you like the video. The VBA course should be out in about 2 weeks time. I'm busy doing the final editing now. Looking forward to your feedback on the course once it's out.