Excel Macro Class 1 - Getting Started Programming Macros
HTML-код
- Опубликовано: 15 сен 2024
- EXCEL VBA COURSE [80% Discount - LIMITED Time Offer]: www.teachexcel...
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
Excel Macros Class 2: • Excel Macros Class 2 -...
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
This is a practical class that gets you started with actually using and creating a macro on your own instead of focusing on the mundane details of things that won't help you right now.
This is a hands-on tutorial and I invite you to download the sample file and work along so you can better learn how to do everything.
After viewing this tutorial, you will be able to create your own very basic macro.
TeachExcel.com
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 :)
Very useful. Thank you so much. Best Excel VBA crash course out there.
best beginner MAcro tutorial ever. easy to understand and follow. better than the evening course i followed.
This is what complete beginner needs, really good job :)
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
Crisp and clean...able to understand easily..
The best explanation on macros I've seen for a beginner. Thank you so much
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.
A perfect video for a beginner. Clear explanation. Thank you...
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 ..
This was a very useful, clear, and easy-to-understand video. Thanks!
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.
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!
I am finally learning Macro which I have been avoiding since 2002.
Well done sir .. Go ahead , we will become very professional programmers within your lessons
Very clear and so simple to follow. Helpful as a start. thanks a lot Dude.
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.
Nice explanation, Very easy understand lay man language.
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: ruclips.net/p/PLxhsXZXQXrUB6Zw8a18hEiJxhgWUxL07i
Let me know your thoughts on the videos so I can make sure they remain useful, relevant, and practical :)
So easy to understand... I will like to download your whole tutorial on RUclips 💪🏾💪🏾
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
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
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!
Simple and elegant to learn. Thanks for sharing
systematic teaching. Easy to learn.
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!
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!
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
best no frill tutorial to explain VBA
Thank you very much :)
Very interesting. Good to learn in the future
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. :)
Glad to help! :) next class will be coming out tomorrow and show you another way to get user input!
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!
Nice video, please upload more videos about this for beginners like me...
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. :)
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
Nice
My first macro
Understand very well
Great
Awesome video. Thank you
Thanks for best tutorial!
Another great video, most helpful well presented and understood. I look forward to more.
Wow, perfect intro video
Really great video. To the point..amazing..no bullshit..pure content
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! :)
Thank you very much... Very nice presentation...
Thank you! I'm very glad you think so :)
Clean and neat tutorial
Thanks! I'm glad you think so :)
It's really helpful. Thank you so much.
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).
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.
very nice tutorial for a beginner it helped so thanks a lot
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.
Perfect this is the way I want to learn.
Keep going sir
Nice slow perfect for a beginner! Thanks.
Perfect set of videos. Straight to the point and a good refresher on VBA.
Awesome tutorial for beginners, thank you!!!!
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.
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 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)
Thanks for sharing, this is very easy to understand even for not native english speakers like me. Cheers from México.
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
This is really helpful. Thank you so much.
Thanks for sharing this....
very good video, so clear and easy to understand !
Thanks! Glad to help))
Easy and Awesome! Thanks
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)
Thank you for a clearly articulated tutorial. Very helpful for a macro newbie like me.
this very good teaching class.
Amazing! Basics couldn't get better. Love from India!
nice content 👍🏽
Hats off! Really well explained even better than courses at Linked Learning( Lynda.com)
Sir u help me understand so quickley i study in class 7 and one to learn all programing sir Please teach pythin or java>?
Love it could you share workbook vlookup also pls
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.
Already corrected it Sir. Thank you.
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
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.
Hello Sir. I am your new subscriber. Thank you so much for such helpful videos. God bless. Regards.
This was very useful. Thank you for making this video.
Good understanding.
perfect video
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.
Just came across your channel. Very helpful content. Thank you very much. Wont be skipping (some) ads to show my support :)
Thanks, very good introduction
The example files aren't available in the link in the description box. :( great tutorial though, tysm for this!
Very good
Thank you
Thank you sir
Thank you so much for your help. you explained like an angel from heavens
Awesome teaching!
Thanks!
thank you
thank you so much
Supper
explanation and very helpful
Sir
Super
I love it, pretty straightforward and easy to understand!
loved the way you explained ! It was pretty clear to me.
Best Macro Tutorial I have seen!
Awesome.
Thanks
Thank you so much , yes it is most use full for me
This is awesome and I need more👍