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! :-)
@@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?
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!
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.
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!
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 :)
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
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.
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.
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.
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?
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.
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.
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 :)
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
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....
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.
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 :)
I can recommend these videos for collections: th-cam.com/video/tg7Vrlxh_RQ/w-d-xo.html&ab_channel=ExcelMacroMastery. The same channel also has some really nice videos for dictionaries
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...
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!
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...
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.
Get access to the full course here 👉 www.xelplus.com/course/excel-vba-excel-macros/
Great ! Mam you just compressed books in a line ... Thank you it helped a lot
the way you simplifying is really awesome, you are an excellent trainer..... 👍
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 ....
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?
Finally plunged into your VBA course and I am enjoying it so far...God bless u!
That's great Vijay. Thanks for your support.
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!
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....
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 :)
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.
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 :)
Thank you so much for covering theory!
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 :)
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.
Brilliant explanation, very easy to follow and to click into place
Thank you Darren. Glad you find the explanation easy to follow.
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.
Great channel, thank you for sharing and the delivery is really good. Thank you for putting time and effort
You're very welcome Karolina.
Very useful. Thank you!
thank you for sharing, excellent explanation, i feel motivated to learn VBA. Greeting from México!!!
That's great to hear :)
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!
Great content, informative and to the point. Thank you
You're very welcome Clifton.
thank you so much for the explanation Ms. Leila.
You're very welcome Ismail.
Good way to explain the content.
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!
Very clear to grasp. Keep it up|
I'm glad to hear it's clear. Thanks for your comment & support!
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!
Awesome tutorials, very well explained and presented ... keep up the great work you doing
Thank you! Glad you like them. Will do my best :)
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
perfect 💪🏻💪🏻 Thanks
You are amazing Leila. An excellent way of explaining properties and methods. Thanks
A wonderful video... Thank you very much indeed!
You're very welcome Marcel :)
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.
Nice !!! 👏👏👏
So nice .
Thanks for you.
You're welcome.
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.
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.
Again thanks a lot mam for this video
You're very welcome Sumit.
6:00 Another method of a shoe is tying the shoelaces.
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
Thanks for the video Ma'am...
You're very welcome Mohit.
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.
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.
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 :)
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
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.
Please do more VBA tutorials this year. 2021. We love u too much
Agreed.
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....
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.
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.
Thanks Mam
Can we stop vba code @ particular date. Example it should not work after one month. Pls help
Thanking you madam, very useful ,
You're very welcome.
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 :)
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: th-cam.com/video/tg7Vrlxh_RQ/w-d-xo.html&ab_channel=ExcelMacroMastery. The same channel also has some really nice videos for dictionaries
Madam how can i print a hidden sheet from so many hidden sheet please help in this.
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.
Easy to understand thx
Where is the vba code examples to create properties & methods?
Thanks Mam Nice Video
You're very welcome. Glad you like it Khalid.
I want to learn advance Excel and VBA full course please help me
As usual, beautifully explained.
When will you start the VBA course?
Thank you. In about two weeks :)
When can we have your course on Udemy
It should be live in about 2 weeks.
@@LeilaGharani Thanks a lot
Nice presentation ):
Thank you Hamidur. Glad you like the presentation. This time on PowerPoint instead of Excel :)
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!
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 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.
I am waiting for your VBA Course video.
Next TH-cam VBA video will be on Thursday --- the course should hopefully be out sometime next week.
Objects Properties and methods.
How to learn vba code as a beginner. Plse give some tips
I recommend taking a structured course.
Thanks
You're welcome.
Can you send me pdf or word to learn vba ????
thanks thanks thanks
Ilove u soo much
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....
I'm lost
Cutie leila..
Вот, отличное объяснение. Жаль не на русском
you are an object... of desire
actually, you are just a shit..
You are very beautiful
Great video as usual Leila, question when is the VBA course to be released? I am waiting for it.