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 :)
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
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!
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
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. :)
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 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 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 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.
This is a very good video for absolute beginners. I understand you have chosen the "Select" example for training purpose only. But you should tell the students that "Select" should be avoided in macros in favour of good programming and computation efficiency. In 20 year I have seen only one or two tasks for which I found no way to avoid "Select" and even don't remember these cases.
Dude...I learned soooo much! THANK YOU!!! (Now I know how to go beyond just 'recording' a macro, and I can even edit the previously recorded macros or just write it from scratch!). Can't wait to learn more, but this gave me a gigantic jump-start as to how the code is structured.
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 .
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!
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
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.
best beginner MAcro tutorial ever. easy to understand and follow. better than the evening course i followed.
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.
A perfect video for a beginner. Clear explanation. Thank you...
This is what complete beginner needs, really good job :)
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.
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!
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
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 :)
Well done sir .. Go ahead , we will become very professional programmers within your lessons
I am finally learning Macro which I have been avoiding since 2002.
This was a very useful, clear, and easy-to-understand video. Thanks!
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.
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
best no frill tutorial to explain VBA
Thank you very much :)
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!
Nice explanation, Very easy understand lay man language.
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!
Very clear and so simple to follow. Helpful as a start. thanks a lot Dude.
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
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. :)
Simple and elegant to learn. Thanks for sharing
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.
Nice video, please upload more videos about this for beginners like me...
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!
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!
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.
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
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.
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.
Nice
My first macro
Understand very well
Great
Perfect set of videos. Straight to the point and a good refresher on VBA.
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Very interesting. Good to learn in the future
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.
The example files aren't available in the link in the description box. :( great tutorial though, tysm for this!
Another great video, most helpful well presented and understood. I look forward to more.
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
Clean and neat tutorial
Thanks! I'm glad you think so :)
This is a very good video for absolute beginners. I understand you have chosen the "Select" example for training purpose only. But you should tell the students that "Select" should be avoided in macros in favour of good programming and computation efficiency. In 20 year I have seen only one or two tasks for which I found no way to avoid "Select" and even don't remember these cases.
very nice tutorial for a beginner it helped so thanks a lot
Thanks for best tutorial!
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! :)
Thanks for sharing, this is very easy to understand even for not native english speakers like me. Cheers from México.
Love it could you share workbook vlookup also pls
Awesome video. Thank you
Dude...I learned soooo much! THANK YOU!!! (Now I know how to go beyond just 'recording' a macro, and I can even edit the previously recorded macros or just write it from scratch!). Can't wait to learn more, but this gave me a gigantic jump-start as to how the code is structured.
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).
Easy and Awesome! Thanks
Sir u help me understand so quickley i study in class 7 and one to learn all programing sir Please teach pythin or java>?
Perfect this is the way I want to learn.
Keep going sir
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)
Good understanding.
Thank you very much... Very nice presentation...
Thank you! I'm very glad you think so :)
Amazing! Basics couldn't get better. Love from India!
very good video, so clear and easy to understand !
Thanks! Glad to help))
Awesome tutorial for beginners, thank you!!!!
This is really helpful. Thank you so much.
I have fetching so many videos... This is the one I could actually understand... Awesome... Thankyou
Wow, perfect intro video
It's really helpful. Thank you so much.
Nice slow perfect for a beginner! Thanks.
Peshavari garam masala konse subji. Main use karna he
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.
Just came across your channel. Very helpful content. Thank you very much. Wont be skipping (some) ads to show my support :)
this very good teaching class.
Gm. Can we prompt user to select a range. Kindly guide
nice content 👍🏽
Hats off! Really well explained even better than courses at Linked Learning( Lynda.com)
Thank you for a clearly articulated tutorial. Very helpful for a macro newbie like me.
Thanks for sharing this....
Is it possible to run a macro by pressing ENTER key directly, without pressing alt+F8 or creating a button?
Best Macro Tutorial I have seen!
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)
Already corrected it Sir. Thank you.
Supper
explanation and very helpful
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
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!
Last one's offset baby is out of world)))
Awesome teaching!
Thanks!
I want to see all your lectures of excell
I was getting errors from Hi example onwards
This is awesome and I need more👍
clean explanation.tq
This was very useful. Thank you for making this video.
Sir
Super
perfect video
Hello Sir. I am your new subscriber. Thank you so much for such helpful videos. God bless. Regards.
loved the way you explained ! It was pretty clear to me.
Very interesting and useful
I love it, pretty straightforward and easy to understand!