MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_NMzSIRQ8qMA 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
Decided to learn macro...searched in google....It was super ..clean and clear tutorial...I will continue this...Thanks for sharing this wonderful tutorial
Really it's awesome way to teach macro by using programming , thanks for making video programmatically. Everybody talks about to Record Macro. And you are the first one ignored Record Macro to make clear concept,... thanks again.. Love from India.
You are very welcome Sachin!!! I'm very happy you like my teaching method :) I'm also almost finished with the full course now! If you're interested, follow the link to signup for a message when its released. www.teachexcel.com/vba-course-update.php
@@TeachExcel Thank you so much for notifying me by your reply. I have visited it's great work done by you on the website And there is lot of to learn. thank again.
I'm a beginner..this session is very much useful for me ... its crisp and clear to understand ..to be frank ur video made me interest to learn macros further ..i really need to appreciate ur work good job keep spreading the knowledge to others ...I have subscribed ur channel .keep going ...not but not least u have very pleasant voice..good luck ..
Thank you! Your classes are very useful. I’m a beginner in Excel. I like how you present and explain them -the title and design, the examples, zoom in and outs, the yellow cursor, speaking voice and pace. Please do make more videos including inventory. :) Thanks again!
Yes please keep them coming. I'm quite new to macros in Win10 an finding it a bit of a struggle. Thanks for all the work you put in. I have a folder that all the email samples go in so that they can be referenced later.
I am putting these tutorials into a playlist now and you can find them here: th-cam.com/play/PLxhsXZXQXrUB6Zw8a18hEiJxhgWUxL07i.html Let me know your thoughts on the videos so I can make sure they remain useful, relevant, and practical :)
Thanks for the beginner's intro to programming with Macros. This is an area I would like to be more familiar with and appreciate your providing an opportunity to do that. Looking forward to your next video!
Thank you! I have developed a payroll system in excel which has been in use since 2014. This is the next step in the development to automate it. I look forward to more lessons!
I used Macros in my work but does not really understand what I'm doing so I just try and error. Thanks to this video. Your tutorial is very easy to understand. Keep it up!
Just watched your tutorial. It gives a good step-by-step intro to macros. Perfect for beginners. Many of the other tutorials I have seen are just too complicated and confusing to follow. Plan to do your other tutorials too. I have subscribed. Pls continue the good work. Tks.
Great stuff, mate. I am quite comfortable with vba but VERY self-taught on a case-by-case basis (ie reseearch what I need for the project of the moment), so although I can do some pretty cool stuff I have great big holes in the basics. Your course is filling those in for me, so thank you very much. :)
I'm really glad you liked it! I'm working on making more of these tutorials and your feedback is very much welcome in regards to what you want to see and learn. :)
This is easy understand and I love your voice . Want to create form in one excel With different . Which mean by selecting name for the form from the dropdown category its component will come up . Same with next form . Guidance please
Step 1: Create a data in another sheet Step 2: Use a combination of Vlookup and Data Validation (List) Mail at: Harshil.taneja@mba.christuniversity.in for further doubts
Thank you! I'm glad you think so :) I'm almost finished with the full course now! If you're interested, follow the link to signup for a message when its released :) www.teachexcel.com/vba-course-update.php
Very simple and easy to understand..just like...art of teaching. Thank you sir😍😃 And I have a question sir... I have a already excel file of Mann kendall which is loading 70 years data but I have 115 year data file which is not loading ( the error is (x(i)=worksheet ("Annual data").cell(rowno, colno) Please sir can you help me.
I watched your video for class 1 yesterday and can't wait to learn more. But a problem has come to one of my Excel workbooks for work. One of the worksheets in my Police Dept employee workbook I created for mail merge data. Today when I went in to add a new officer, the cells didn't have the outline border highlighted and the grab handle on the bottom right of the cell, to show which cell I was in. I couldn't figure out why so I decided to look at any code that might be in the VBA window. I pressed Alt + F11 and it went directly to the VBA window. But there wasn't any code available to look at. So I Pressed Alt + F11 again to go to the worksheet window. But it didn't go there. I did this 4 times with no luck. Then I noticed that what it did was bring up 4 chart worksheets. There isn't anything on these sheets but it is in the design mode for excel. The problem is that I can't delete these sheets. So please, can anybody help me figure out: 1) How to delete these 4 Chart worksheets 2) Tell me what is wrong with my Mail Merge data sheet and how to fix it. Thanks so very much!!!!
Now I see your comment here - it takes time for me to go through them all sometimes. Anyway, I replied to your forum post a couple of days ago; check that out and reply to me there if my suggestions didn't help.
i can not thanks you enough ! you save my back as i have been navigating here and there to get the essence and the logic !! in very amazing way you put everything out easily ! thank you very much for your valuable videos .
I believe Alt+F11 does not simply open up VBA just like that without set up anything yet. Please clarify. OK. I need to first make DEVELOPER tab visible on top, to do that, click FILE > OPTIONS, click "Customize Ribbon" , tick "Developer" tab
It does. Try it! I have never had to set anything up to access the VBA window using Alt + F11. I have not used Excel on a mac through so I can't speak to that.
Could you put or assign any name of the macro, like for example "Sub Unknown"? Where does that name came from? It's a bit confussion to me as beginner where that came from. Please help, no video has covered nor explain where that was derived from.
hello! how can i extract numbers with criteria through macro? for example, i need to extract 10 digit number that starts with 5609 or 5881 etc and the output will go to the rows / each 10 digit number on the same row but separate numbers? thank you so much!
thank you so much for this video.....i really need to learn this...thank you so much i will subscribe ur channel and press bell to....and learn all tutorials about macros.....thank you soo much...!!!!
MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_NMzSIRQ8qMA
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
I have seen lot of macro videos. This is by far the best way to teach someone how makro works. Thanks!
I'm really glad you liked it! I'll continue the series with a tutorial this week for the second class and I hope it will be as useful :)
Decided to learn macro...searched in google....It was super ..clean and clear tutorial...I will continue this...Thanks for sharing this wonderful tutorial
Thank you! I'm glad I could help :)
@@TeachExcel I really need help to learn macro please contact me my email is mdatikuzzaman87@gmail.com please contact me asap many thanks
best beginner MAcro tutorial ever. easy to understand and follow. better than the evening course i followed.
Really it's awesome way to teach macro by using programming , thanks for making video programmatically. Everybody talks about to Record Macro. And you are the first one ignored Record Macro to make clear concept,... thanks again.. Love from India.
You are very welcome Sachin!!! I'm very happy you like my teaching method :) I'm also almost finished with the full course now! If you're interested, follow the link to signup for a message when its released. www.teachexcel.com/vba-course-update.php
@@TeachExcel Thank you so much for notifying me by your reply. I have visited it's great work done by you on the website And there is lot of to learn. thank again.
The best explanation on macros I've seen for a beginner. Thank you so much
I'm a beginner..this session is very much useful for me ... its crisp and clear to understand ..to be frank ur video made me interest to learn macros further ..i really need to appreciate ur work good job keep spreading the knowledge to others ...I have subscribed ur channel .keep going ...not but not least u have very pleasant voice..good luck ..
Very useful. Thank you so much. Best Excel VBA crash course out there.
This is what complete beginner needs, really good job :)
Crisp and clean...able to understand easily..
Thank you! Your classes are very useful. I’m a beginner in Excel. I like how you present and explain them -the title and design, the examples, zoom in and outs, the yellow cursor, speaking voice and pace. Please do make more videos including inventory. :) Thanks again!
A perfect video for a beginner. Clear explanation. Thank you...
Yes please keep them coming. I'm quite new to macros in Win10 an finding it a bit of a struggle. Thanks for all the work you put in. I have a folder that all the email samples go in so that they can be referenced later.
Thanks! I'm so glad that you like the tutorials and that I can help!! :)
ditto bob`s comment
I am putting these tutorials into a playlist now and you can find them here: th-cam.com/play/PLxhsXZXQXrUB6Zw8a18hEiJxhgWUxL07i.html
Let me know your thoughts on the videos so I can make sure they remain useful, relevant, and practical :)
Decided to learn this between starting my further accounts studies. Thankyou!!! This is really useful.
Glad you like it! If you have any questions or thoughts, let me know! I want to make sure the series is as useful as possible.
Well done sir .. Go ahead , we will become very professional programmers within your lessons
I always loved Excel but doing code on it is mind blowing to me
The full course will blow your mind then :) You can follow the link in the description of this video to get more info on it.
Thanks for the beginner's intro to programming with Macros. This is an area I would like to be more familiar with and appreciate your providing an opportunity to do that. Looking forward to your next video!
Thanks for the support!
This was a very useful, clear, and easy-to-understand video. Thanks!
Very clear and so simple to follow. Helpful as a start. thanks a lot Dude.
Thank you! I have developed a payroll system in excel which has been in use since 2014. This is the next step in the development to automate it. I look forward to more lessons!
I used Macros in my work but does not really understand what I'm doing so I just try and error. Thanks to this video. Your tutorial is very easy to understand. Keep it up!
best no frill tutorial to explain VBA
Thank you very much :)
Just watched your tutorial. It gives a good step-by-step intro to macros. Perfect for beginners. Many of the other tutorials I have seen are just too complicated and confusing to follow. Plan to do your other tutorials too. I have subscribed. Pls continue the good work. Tks.
So easy to understand... I will like to download your whole tutorial on TH-cam 💪🏾💪🏾
The full course is coming soon! :)
Can’t wait... ur a good teacher... been trying to learn this thingy for years but wouldn’t just understand lolzz
Great stuff, mate. I am quite comfortable with vba but VERY self-taught on a case-by-case basis (ie reseearch what I need for the project of the moment), so although I can do some pretty cool stuff I have great big holes in the basics. Your course is filling those in for me, so thank you very much. :)
Glad to help! :) next class will be coming out tomorrow and show you another way to get user input!
Thanks! Only vba video in you tube which i could understand for beginners. Hope this series will help me to get where I want to...
I'm really glad you liked it! I'm working on making more of these tutorials and your feedback is very much welcome in regards to what you want to see and learn. :)
systematic teaching. Easy to learn.
This is easy understand and I love your voice .
Want to create form in one excel
With different .
Which mean by selecting name for the form from the dropdown category its component will come up . Same with next form .
Guidance please
Step 1: Create a data in another sheet
Step 2: Use a combination of Vlookup and Data Validation (List)
Mail at: Harshil.taneja@mba.christuniversity.in for further doubts
Simple and elegant to learn. Thanks for sharing
This was the best Macro video i have seen by far. Thank you for posting this, I look forward to watching the rest of your videos!🤗
I'm so glad you liked it :) Let me know if you have any thoughts on the next macro tutorials I should make!
Another great video, most helpful well presented and understood. I look forward to more.
I am finally learning Macro which I have been avoiding since 2002.
Nice explanation, Very easy understand lay man language.
Perfect this is the way I want to learn.
Keep going sir
Perfect set of videos. Straight to the point and a good refresher on VBA.
You present very well man. Thanks
Thank you! I'm glad you think so :) I'm almost finished with the full course now! If you're interested, follow the link to signup for a message when its released :) www.teachexcel.com/vba-course-update.php
Very interesting. Good to learn in the future
Wow, perfect intro video
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
I absolutely loved this video. You made VBA's seem very simple and fun. You cleared up a lot of things. I can't wait to watch your other videos.
Really great video. To the point..amazing..no bullshit..pure content
Today I decided to learn macro so please continue it and plz reply if I have some problem.Mate how to use macro recorded in different workbooks
Good intro well explained with easy to follow examples
I'm glad you think so! If you are interested in more tutorial for this Macro series, let me know your thoughts! :)
Nice video, please upload more videos about this for beginners like me...
very nice tutorial for a beginner it helped so thanks a lot
Very simple and easy to understand..just like...art of teaching. Thank you sir😍😃
And I have a question sir...
I have a already excel file of Mann kendall which is loading 70 years data but I have 115 year data file which is not loading ( the error is (x(i)=worksheet ("Annual data").cell(rowno, colno)
Please sir can you help me.
It's really helpful. Thank you so much.
Nice slow perfect for a beginner! Thanks.
I watched your video for class 1 yesterday and can't wait to learn more. But a problem has come to one of my Excel workbooks for work. One of the worksheets in my Police Dept employee workbook I created for mail merge data. Today when I went in to add a new officer, the cells didn't have the outline border highlighted and the grab handle on the bottom right of the cell, to show which cell I was in. I couldn't figure out why so I decided to look at any code that might be in the VBA window. I pressed Alt + F11 and it went directly to the VBA window. But there wasn't any code available to look at. So I Pressed Alt + F11 again to go to the worksheet window. But it didn't go there. I did this 4 times with no luck. Then I noticed that what it did was bring up 4 chart worksheets. There isn't anything on these sheets but it is in the design mode for excel. The problem is that I can't delete these sheets.
So please, can anybody help me figure out:
1) How to delete these 4 Chart worksheets
2) Tell me what is wrong with my Mail Merge data sheet and how to fix it.
Thanks so very much!!!!
Now I see your comment here - it takes time for me to go through them all sometimes. Anyway, I replied to your forum post a couple of days ago; check that out and reply to me there if my suggestions didn't help.
very good video, so clear and easy to understand !
Thanks! Glad to help))
Great job and thank you for sharing. I'll watch all your vids.
Thanks! Let me know if you have any questions and I can help here or on the forum on TeachExcel.com
Awesome tutorial for beginners, thank you!!!!
i can not thanks you enough ! you save my back as i have been navigating here and there to get the essence and the logic !! in very amazing way you put everything out easily ! thank you very much for your valuable videos .
You're very welcome! Glad to help)
This is really helpful. Thank you so much.
Nice
My first macro
Understand very well
Great
Perfect and very useful video, simple to understand by the beginners like me. Thank you so much 👍❤️
You're very welcome! I'm glad you like it)
Easy and Awesome! Thanks
cool, been putting this off, but you should expain marcro are used way more then just in excel. I did this stuff 20 years ago.
Best Macro Tutorial I have seen!
Already corrected it Sir. Thank you.
Clean and neat tutorial
Thanks! I'm glad you think so :)
The example files aren't available in the link in the description box. :( great tutorial though, tysm for this!
Thank you for sharing!
You are very welcome Tom! Don't forget to signup for the full course if you like the video (link in the description).
Amazing! Basics couldn't get better. Love from India!
Sir u help me understand so quickley i study in class 7 and one to learn all programing sir Please teach pythin or java>?
I have fetching so many videos... This is the one I could actually understand... Awesome... Thankyou
I believe Alt+F11 does not simply open up VBA just like that without set up anything yet. Please clarify.
OK. I need to first make DEVELOPER tab visible on top, to do that, click FILE > OPTIONS, click "Customize Ribbon" , tick "Developer" tab
It does. Try it! I have never had to set anything up to access the VBA window using Alt + F11. I have not used Excel on a mac through so I can't speak to that.
Hello Sir. I am your new subscriber. Thank you so much for such helpful videos. God bless. Regards.
Last one's offset baby is out of world)))
Thank you very much... Very nice presentation...
Thank you! I'm very glad you think so :)
Supper
explanation and very helpful
Hats off! Really well explained even better than courses at Linked Learning( Lynda.com)
Good understanding.
Thanks for best tutorial!
this very good teaching class.
Awesome video. Thank you
This was very useful. Thank you for making this video.
loved the way you explained ! It was pretty clear to me.
This is awesome and I need more👍
Thanks for sharing, this is very easy to understand even for not native english speakers like me. Cheers from México.
Thank you for a clearly articulated tutorial. Very helpful for a macro newbie like me.
Thanks for sharing this....
Awesome teaching!
Thanks!
Is it possible to run a macro by pressing ENTER key directly, without pressing alt+F8 or creating a button?
Very interesting and useful
Thanks, very good introduction
clean explanation.tq
Offset baby :D Great video
I love it, pretty straightforward and easy to understand!
Absolutely Great Tutorial, very clear presentation!
Could you put or assign any name of the macro, like for example "Sub Unknown"? Where does that name came from? It's a bit confussion to me as beginner where that came from. Please help, no video has covered nor explain where that was derived from.
Thank you so much for your help. you explained like an angel from heavens
hello! how can i extract numbers with criteria through macro? for example, i need to extract 10 digit number that starts with 5609 or 5881 etc and the output will go to the rows / each 10 digit number on the same row but separate numbers? thank you so much!
Wow, Really nice Tutorial for the beginners like me. So detailed video. Thank u very much Sir. Take respect. Stay well. thanks again.
Sir
Super
"OFFSET BABY!"
thank you so much for this video.....i really need to learn this...thank you so much i will subscribe ur channel and press bell to....and learn all tutorials about macros.....thank you soo much...!!!!
You're so very welcome! I'm glad you like them :)
perfect video
Thank you for this great tutorial!
You're very welcome :)
Thank you sir