Excel Macro Class 1 - Getting Started Programming Macros

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 พ.ย. 2024

ความคิดเห็น •

  • @TeachExcel
    @TeachExcel  2 ปีที่แล้ว +2

    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

  • @alexrosen8762
    @alexrosen8762 6 ปีที่แล้ว +5

    I have seen lot of macro videos. This is by far the best way to teach someone how makro works. Thanks!

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว +2

      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 :)

  • @VarunKumar-xt4jq
    @VarunKumar-xt4jq 5 ปีที่แล้ว +17

    Decided to learn macro...searched in google....It was super ..clean and clear tutorial...I will continue this...Thanks for sharing this wonderful tutorial

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว +1

      Thank you! I'm glad I could help :)

    • @aryenatikuzzaman
      @aryenatikuzzaman 4 ปีที่แล้ว +1

      @@TeachExcel I really need help to learn macro please contact me my email is mdatikuzzaman87@gmail.com please contact me asap many thanks

  • @views-cx9eb
    @views-cx9eb 4 ปีที่แล้ว

    best beginner MAcro tutorial ever. easy to understand and follow. better than the evening course i followed.

  • @sachinkanchan5506
    @sachinkanchan5506 4 ปีที่แล้ว +1

    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.

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว

      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

    • @sachinkanchan5506
      @sachinkanchan5506 4 ปีที่แล้ว

      @@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.

  • @kenneth27089
    @kenneth27089 2 ปีที่แล้ว

    The best explanation on macros I've seen for a beginner. Thank you so much

  • @krithianu3703
    @krithianu3703 4 ปีที่แล้ว

    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 ..

  • @Al-vw7qi
    @Al-vw7qi 3 ปีที่แล้ว +1

    Very useful. Thank you so much. Best Excel VBA crash course out there.

  • @SimpleExcelVBA
    @SimpleExcelVBA 3 ปีที่แล้ว +2

    This is what complete beginner needs, really good job :)

  • @ankitmaheshwari6746
    @ankitmaheshwari6746 5 ปีที่แล้ว +38

    Crisp and clean...able to understand easily..

  • @kayellanto7598
    @kayellanto7598 5 ปีที่แล้ว +3

    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!

  • @officetricks6303
    @officetricks6303 2 ปีที่แล้ว +1

    A perfect video for a beginner. Clear explanation. Thank you...

  • @bobwebber8521
    @bobwebber8521 6 ปีที่แล้ว +2

    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.

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว

      Thanks! I'm so glad that you like the tutorials and that I can help!! :)

    • @jazzbrad6333
      @jazzbrad6333 6 ปีที่แล้ว

      ditto bob`s comment

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว

      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 :)

  • @drylunch6400
    @drylunch6400 6 ปีที่แล้ว +11

    Decided to learn this between starting my further accounts studies. Thankyou!!! This is really useful.

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว +1

      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.

  • @mahmoudhassan6627
    @mahmoudhassan6627 4 ปีที่แล้ว +1

    Well done sir .. Go ahead , we will become very professional programmers within your lessons

  • @christophermoawad9930
    @christophermoawad9930 3 ปีที่แล้ว +7

    I always loved Excel but doing code on it is mind blowing to me

    • @TeachExcel
      @TeachExcel  3 ปีที่แล้ว

      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.

  • @johnlongo154
    @johnlongo154 6 ปีที่แล้ว +1

    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!

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว

      Thanks for the support!

  • @mkmstillstackin
    @mkmstillstackin 5 ปีที่แล้ว +6

    This was a very useful, clear, and easy-to-understand video. Thanks!

  • @maamounegaabouri6529
    @maamounegaabouri6529 6 ปีที่แล้ว +4

    Very clear and so simple to follow. Helpful as a start. thanks a lot Dude.

  • @edwinenriquez5041
    @edwinenriquez5041 6 ปีที่แล้ว +1

    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!

  • @johngavijan5668
    @johngavijan5668 5 ปีที่แล้ว +1

    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!

  • @jengtsai1033
    @jengtsai1033 4 ปีที่แล้ว

    best no frill tutorial to explain VBA

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว

      Thank you very much :)

  • @vslingam000
    @vslingam000 6 ปีที่แล้ว +1

    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.

  • @MeMe-ef3bq
    @MeMe-ef3bq 4 ปีที่แล้ว +1

    So easy to understand... I will like to download your whole tutorial on TH-cam 💪🏾💪🏾

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว +1

      The full course is coming soon! :)

    • @MeMe-ef3bq
      @MeMe-ef3bq 4 ปีที่แล้ว

      Can’t wait... ur a good teacher... been trying to learn this thingy for years but wouldn’t just understand lolzz

  • @graememcgregor8407
    @graememcgregor8407 6 ปีที่แล้ว +1

    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. :)

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว +1

      Glad to help! :) next class will be coming out tomorrow and show you another way to get user input!

  • @123kar123kar
    @123kar123kar 5 ปีที่แล้ว

    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...

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว +1

      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. :)

  • @shivkumarr9060
    @shivkumarr9060 4 ปีที่แล้ว

    systematic teaching. Easy to learn.

  • @elf153
    @elf153 5 ปีที่แล้ว +15

    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

    • @HARSHILTANEJA
      @HARSHILTANEJA 5 ปีที่แล้ว

      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

  • @surfer80988
    @surfer80988 3 ปีที่แล้ว

    Simple and elegant to learn. Thanks for sharing

  • @paolalopez518
    @paolalopez518 6 ปีที่แล้ว +1

    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!🤗

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว +1

      I'm so glad you liked it :) Let me know if you have any thoughts on the next macro tutorials I should make!

  • @jonpye444
    @jonpye444 4 ปีที่แล้ว

    Another great video, most helpful well presented and understood. I look forward to more.

  • @MyRockMyFortress
    @MyRockMyFortress 2 ปีที่แล้ว

    I am finally learning Macro which I have been avoiding since 2002.

  • @manigandanrajagopal5238
    @manigandanrajagopal5238 4 ปีที่แล้ว

    Nice explanation, Very easy understand lay man language.

  • @challasandeepreddy
    @challasandeepreddy 5 ปีที่แล้ว +1

    Perfect this is the way I want to learn.
    Keep going sir

  • @larrysalinas4507
    @larrysalinas4507 4 ปีที่แล้ว

    Perfect set of videos. Straight to the point and a good refresher on VBA.

  • @monojshaw3720
    @monojshaw3720 4 ปีที่แล้ว +1

    You present very well man. Thanks

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว

      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

  • @BOWENSblog
    @BOWENSblog 4 ปีที่แล้ว +1

    Very interesting. Good to learn in the future

  • @Noble909
    @Noble909 5 ปีที่แล้ว +2

    Wow, perfect intro video

  • @natashasamuel9346
    @natashasamuel9346 3 ปีที่แล้ว

    Great class.
    Keep up the good work.
    Thank You,
    Natasha Samuel

  • @shenay9377
    @shenay9377 4 ปีที่แล้ว

    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.

  • @adityataneja86
    @adityataneja86 5 ปีที่แล้ว

    Really great video. To the point..amazing..no bullshit..pure content

  • @kirandeepchoudhry9232
    @kirandeepchoudhry9232 5 ปีที่แล้ว +1

    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

  • @zzzzzzzzzzzzzzzz9
    @zzzzzzzzzzzzzzzz9 6 ปีที่แล้ว +1

    Good intro well explained with easy to follow examples

    • @TeachExcel
      @TeachExcel  6 ปีที่แล้ว

      I'm glad you think so! If you are interested in more tutorial for this Macro series, let me know your thoughts! :)

  • @BARTLANTV
    @BARTLANTV 3 ปีที่แล้ว

    Nice video, please upload more videos about this for beginners like me...

  • @jahanzebkhan2489
    @jahanzebkhan2489 5 ปีที่แล้ว

    very nice tutorial for a beginner it helped so thanks a lot

  • @amankakkar5846
    @amankakkar5846 4 ปีที่แล้ว

    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.

  • @muhammadaamirhussein3529
    @muhammadaamirhussein3529 5 ปีที่แล้ว +1

    It's really helpful. Thank you so much.

  • @ralfses
    @ralfses 4 ปีที่แล้ว

    Nice slow perfect for a beginner! Thanks.

  • @pat6703
    @pat6703 4 ปีที่แล้ว

    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!!!!

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว

      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.

  • @HH-tb1gh
    @HH-tb1gh 5 ปีที่แล้ว

    very good video, so clear and easy to understand !

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว

      Thanks! Glad to help))

  • @chancegoethe5022
    @chancegoethe5022 5 ปีที่แล้ว

    Great job and thank you for sharing. I'll watch all your vids.

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว

      Thanks! Let me know if you have any questions and I can help here or on the forum on TeachExcel.com

  • @jinocj9964
    @jinocj9964 4 ปีที่แล้ว

    Awesome tutorial for beginners, thank you!!!!

  • @shahindaalkhalifa6930
    @shahindaalkhalifa6930 5 ปีที่แล้ว

    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 .

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว

      You're very welcome! Glad to help)

  • @nicknguyen6016
    @nicknguyen6016 4 ปีที่แล้ว

    This is really helpful. Thank you so much.

  • @sapnaapnaapna
    @sapnaapnaapna 3 ปีที่แล้ว

    Nice
    My first macro
    Understand very well
    Great

  • @rekhapons3400
    @rekhapons3400 5 ปีที่แล้ว +1

    Perfect and very useful video, simple to understand by the beginners like me. Thank you so much 👍❤️

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว

      You're very welcome! I'm glad you like it)

  • @noahligpitan4067
    @noahligpitan4067 4 ปีที่แล้ว

    Easy and Awesome! Thanks

  • @Hydrogenagent
    @Hydrogenagent 5 ปีที่แล้ว

    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.

  • @yusufgillani532
    @yusufgillani532 5 ปีที่แล้ว

    Best Macro Tutorial I have seen!

  • @romeodariochiu8137
    @romeodariochiu8137 4 ปีที่แล้ว

    Already corrected it Sir. Thank you.

  • @ItsMyLifeAsh
    @ItsMyLifeAsh 3 ปีที่แล้ว

    Clean and neat tutorial

    • @TeachExcel
      @TeachExcel  3 ปีที่แล้ว

      Thanks! I'm glad you think so :)

  • @jennhaefner3149
    @jennhaefner3149 3 ปีที่แล้ว

    The example files aren't available in the link in the description box. :( great tutorial though, tysm for this!

  • @tomatae8136
    @tomatae8136 4 ปีที่แล้ว +1

    Thank you for sharing!

    • @TeachExcel
      @TeachExcel  4 ปีที่แล้ว

      You are very welcome Tom! Don't forget to signup for the full course if you like the video (link in the description).

  • @HARSHILTANEJA
    @HARSHILTANEJA 5 ปีที่แล้ว

    Amazing! Basics couldn't get better. Love from India!

  • @learningisfun2.038
    @learningisfun2.038 4 ปีที่แล้ว +1

    Sir u help me understand so quickley i study in class 7 and one to learn all programing sir Please teach pythin or java>?

  • @beblet
    @beblet 4 ปีที่แล้ว

    I have fetching so many videos... This is the one I could actually understand... Awesome... Thankyou

  • @elliotching1142
    @elliotching1142 5 ปีที่แล้ว

    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

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว

      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.

  • @barshadas6268
    @barshadas6268 6 ปีที่แล้ว +2

    Hello Sir. I am your new subscriber. Thank you so much for such helpful videos. God bless. Regards.

  • @allahverdiyunusov6908
    @allahverdiyunusov6908 5 ปีที่แล้ว

    Last one's offset baby is out of world)))

  • @sureshbabutg827
    @sureshbabutg827 3 ปีที่แล้ว

    Thank you very much... Very nice presentation...

    • @TeachExcel
      @TeachExcel  3 ปีที่แล้ว

      Thank you! I'm very glad you think so :)

  • @thebesttechnical3608
    @thebesttechnical3608 5 ปีที่แล้ว

    Supper
    explanation and very helpful

  • @saurabhbhardwaj7951
    @saurabhbhardwaj7951 5 ปีที่แล้ว +1

    Hats off! Really well explained even better than courses at Linked Learning( Lynda.com)

  • @mehedi816
    @mehedi816 4 ปีที่แล้ว

    Good understanding.

  • @realmotivation2291
    @realmotivation2291 3 ปีที่แล้ว

    Thanks for best tutorial!

  • @abhijitbhokare8082
    @abhijitbhokare8082 4 ปีที่แล้ว

    this very good teaching class.

  • @AJ-et3vf
    @AJ-et3vf ปีที่แล้ว

    Awesome video. Thank you

  • @KaizerKilborn
    @KaizerKilborn 5 ปีที่แล้ว +1

    This was very useful. Thank you for making this video.

  • @rahultiwari2627
    @rahultiwari2627 5 ปีที่แล้ว

    loved the way you explained ! It was pretty clear to me.

  • @celestinareed7578
    @celestinareed7578 5 ปีที่แล้ว

    This is awesome and I need more👍

  • @excel-finanzas-pakal5559
    @excel-finanzas-pakal5559 5 ปีที่แล้ว

    Thanks for sharing, this is very easy to understand even for not native english speakers like me. Cheers from México.

  • @miamzd1
    @miamzd1 5 ปีที่แล้ว

    Thank you for a clearly articulated tutorial. Very helpful for a macro newbie like me.

  • @MusikaAtIbaPa
    @MusikaAtIbaPa 3 ปีที่แล้ว

    Thanks for sharing this....

  • @jamesbukachi6830
    @jamesbukachi6830 6 ปีที่แล้ว +1

    Awesome teaching!

  • @rollyravelo4301
    @rollyravelo4301 5 ปีที่แล้ว

    Is it possible to run a macro by pressing ENTER key directly, without pressing alt+F8 or creating a button?

  • @feelingzhakkaas
    @feelingzhakkaas 5 ปีที่แล้ว

    Very interesting and useful

  • @turradaturra
    @turradaturra 5 ปีที่แล้ว

    Thanks, very good introduction

  • @raogaru306
    @raogaru306 5 ปีที่แล้ว

    clean explanation.tq

  • @hamidmghazi
    @hamidmghazi 4 ปีที่แล้ว

    Offset baby :D Great video

  • @iamcarlosamaya
    @iamcarlosamaya 5 ปีที่แล้ว

    I love it, pretty straightforward and easy to understand!

  • @albertdesilva2087
    @albertdesilva2087 4 ปีที่แล้ว

    Absolutely Great Tutorial, very clear presentation!

  • @vincebrindale6410
    @vincebrindale6410 3 ปีที่แล้ว

    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.

  • @mujahed4589
    @mujahed4589 5 ปีที่แล้ว

    Thank you so much for your help. you explained like an angel from heavens

  • @leahgee2263
    @leahgee2263 4 ปีที่แล้ว

    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!

  • @aminulislam-lj1my
    @aminulislam-lj1my 4 ปีที่แล้ว

    Wow, Really nice Tutorial for the beginners like me. So detailed video. Thank u very much Sir. Take respect. Stay well. thanks again.

  • @sreedharlikit8966
    @sreedharlikit8966 ปีที่แล้ว

    Sir
    Super

  • @Ali-cb9vk
    @Ali-cb9vk 4 ปีที่แล้ว

    "OFFSET BABY!"

  • @GREATESTTASTEOFINDIA
    @GREATESTTASTEOFINDIA 5 ปีที่แล้ว

    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...!!!!

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว +2

      You're so very welcome! I'm glad you like them :)

  • @husseinalwahab23
    @husseinalwahab23 2 ปีที่แล้ว

    perfect video

  • @yarks854
    @yarks854 5 ปีที่แล้ว

    Thank you for this great tutorial!

    • @TeachExcel
      @TeachExcel  5 ปีที่แล้ว +1

      You're very welcome :)

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi2255 2 ปีที่แล้ว

    Thank you sir