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
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.
Decided to learn macro...searched in google....It was super ..clean and clear tutorial...I will continue this...Thanks for sharing this wonderful tutorial
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 ..
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: ua-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! 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!
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'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
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'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.
My Excel file has with few cells having ||. how can I remove these characters using vba macro? example cell AC64 has 2020-07-24 17:00:00||2020-07-24 17:00:00 Any suggestions?
Please ask in the forum on teachexcel.com and upload a sample file. But you could use find/replace to do it without a macro if you want and that works quickly.
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. :)
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!
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.
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.
How to get data from Excel and fill in to another system with (auto or fast)? I have hundred of data need to key by manually (copy & paste) 1 by 1😴 into system (Arcus). Do you know how to help on me with or some tricks?
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!
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 .
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 confused about the downloadable files you say and show in your video we can download to follow along in our excel. I've opened every link you show above but there are only a lot of downloadable tutorials but there isn't any files to download for this tutorial to use on our computer.
Click the link in the description next to Excel File: www.teachexcel.com/excel-tutorial/2059/excel-macros-class-1-getting-started-programming-macros?nav=yt Then look to the grey box in the right column that says "Tutorial Details" and, next to "Downloadable Files" in that box, click "Excel File"
hi, pls help in pasting ONLY in Visible cells. I am copying data(unfiltered, a list of all products sales ) and wants to paste into another table(filtered table), but it does fill all the cells with same values.
Hi! I've just been trying this range("A2").Value = "gov." and it's not working at all. Every time I do it, it gives me an error and I don't know why. Can you help me with that?
Hi does anyone having same issue as mine, im trying to export data from access to excel, in access the data is refreshed, but when i try to export it to the linked excel file, the excel file is not working. Any suggestion for this issue please?
Please help, I need to sort a list of words in alphabetic order, but not from left side of the words as usual, but from the right side, endings of words.
Go to Run > Reset from the top menu. You probably had a previous error and clicked the "Debug" button and so the window is still in that kind of debugging mode and you just need to get it out of it.
Hii there. I have doubt when I was trying to do what you teach I got this - Cant execute while in break mode. And I dont understand where I went wrong can u plz help me?
It is a debugging mode that can happen on purpose or, most likely, by accident, when an error occurs. Click the "stop" button at the top of the window and it should reset it back to normal. If you don't see the stop button, go to Run > Reset in the top menu.
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.
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.
Hello, this video has been very helpful. However, when I do the: Range("B2").Value = "Hey there!" I get back an error that says Can't execute in break mode. What am I doing wrong?
You have one running already. In the VBA window, click the "Stop" button at the top of the window. If you don't see it, go to the Run menu and click Reset. If you have any more questions, feel free to upload a sample file to our forum and ask there: www.teachexcel.com/talk/microsoft-office?src=yt
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 :)
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
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.
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
Very useful. Thank you so much. Best Excel VBA crash course out there.
This is what complete beginner needs, really good job :)
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 ..
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: ua-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! 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!
Crisp and clean...able to understand easily..
Well done sir .. Go ahead , we will become very professional programmers within your lessons
So easy to understand... I will like to download your whole tutorial on UA-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
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
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.
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
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!
Nice explanation, Very easy understand lay man language.
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Another great video, most helpful well presented and understood. I look forward to more.
Gm. Can we prompt user to select a range. Kindly guide
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.
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.
Very interesting. Good to learn in the future
My Excel file has with few cells having ||. how can I remove these characters using vba macro? example cell AC64 has 2020-07-24 17:00:00||2020-07-24 17:00:00
Any suggestions?
Please ask in the forum on teachexcel.com and upload a sample file. But you could use find/replace to do it without a macro if you want and that works quickly.
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 was getting errors from Hi example onwards
Perfect set of videos. Straight to the point and a good refresher on VBA.
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!
best no frill tutorial to explain VBA
Thank you very much :)
Nice video, please upload more videos about this for beginners like me...
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.
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.
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
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.
How to get data from Excel and fill in to another system with (auto or fast)? I have hundred of data need to key by manually (copy & paste) 1 by 1😴 into system (Arcus). Do you know how to help on me with or some tricks?
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!
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! :)
Really great video. To the point..amazing..no bullshit..pure content
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 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 confused about the downloadable files you say and show in your video we can download to follow along in our excel. I've opened every link you show above but there are only a lot of downloadable tutorials but there isn't any files to download for this tutorial to use on our computer.
Click the link in the description next to Excel File: www.teachexcel.com/excel-tutorial/2059/excel-macros-class-1-getting-started-programming-macros?nav=yt
Then look to the grey box in the right column that says "Tutorial Details" and, next to "Downloadable Files" in that box, click "Excel File"
hi, pls help in pasting ONLY in Visible cells. I am copying data(unfiltered, a list of all products sales ) and wants to paste into another table(filtered table), but it does fill all the cells with same values.
The example files aren't available in the link in the description box. :( great tutorial though, tysm for this!
Just came across your channel. Very helpful content. Thank you very much. Wont be skipping (some) ads to show my support :)
Peshavari garam masala konse subji. Main use karna he
Thanks for sharing, this is very easy to understand even for not native english speakers like me. Cheers from México.
very good video, so clear and easy to understand !
Thanks! Glad to help))
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.
Hi! I've just been trying this range("A2").Value = "gov." and it's not working at all. Every time I do it, it gives me an error and I don't know why. Can you help me with that?
Amazing! Basics couldn't get better. Love from India!
macro tab accidentally close. how to recover?
Pls help Me.
I have employees attendance in Sheet 1 and employees Leave entries to updated in Sheet 2 automatically though Macro or any other option.
Hi does anyone having same issue as mine, im trying to export data from access to excel, in access the data is refreshed, but when i try to export it to the linked excel file, the excel file is not working. Any suggestion for this issue please?
Im using laptop, ALT+F11 dont work.. what else to do?
Please help, I need to sort a list of words in alphabetic order, but not from left side of the words as usual, but from the right side, endings of words.
Is it possible to run a macro by pressing ENTER key directly, without pressing alt+F8 or creating a button?
Clean and neat tutorial
Thanks! I'm glad you think so :)
Nice
My first macro
Understand very well
Great
Easy and Awesome! Thanks
Perfect this is the way I want to learn.
Keep going sir
Can't proceed to sheet sir. Pop up box quote: Can't execute code in break mode. Thank you
very nice tutorial for a beginner it helped so thanks a lot
This is really helpful. Thank you so much.
Awesome video. Thank you
I have fetching so many videos... This is the one I could actually understand... Awesome... Thankyou
sir also one query..
what if u write capital letters insted of small will the program still work becaause mine does but im not sure
please anyone>?
Wow, perfect intro video
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).
Awesome tutorial for beginners, thank you!!!!
Why I'm getting error of Cant execute code in break mode
Go to Run > Reset from the top menu. You probably had a previous error and clicked the "Debug" button and so the window is still in that kind of debugging mode and you just need to get it out of it.
Nice slow perfect for a beginner! Thanks.
I am finally learning Macro which I have been avoiding since 2002.
perfect video
It's really helpful. Thank you so much.
Love it could you share workbook vlookup also pls
Hii there. I have doubt when I was trying to do what you teach I got this - Cant execute while in break mode. And I dont understand where I went wrong can u plz help me?
It is a debugging mode that can happen on purpose or, most likely, by accident, when an error occurs. Click the "stop" button at the top of the window and it should reset it back to normal. If you don't see the stop button, go to Run > Reset in the top menu.
Thank you so much
Is it sufficient for me learn full macro if i watch your macro vedio alone?
Thanks for best tutorial!
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.
Hi, Can you please let me know what is the software that you are using to capture the desktop screen
Camtasia - it's expensive though so i would try something that is free if you are just starting out.
this very good teaching class.
I couldn't see the file to download
It's in the grey box titled "Tutorial Details" and is the link called "Excel File" - in the tutorial at 14 seconds, you will see this highlighted.
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
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.
Thank you very much... Very nice presentation...
Thank you! I'm very glad you think so :)
Good understanding.
It shows can't excute in break model
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 awesome and I need more👍
Thank you for a clearly articulated tutorial. Very helpful for a macro newbie like me.
Best Macro Tutorial I have seen!
nice content 👍🏽
Hello, this video has been very helpful. However, when I do the: Range("B2").Value = "Hey there!" I get back an error that says Can't execute in break mode. What am I doing wrong?
You have one running already. In the VBA window, click the "Stop" button at the top of the window. If you don't see it, go to the Run menu and click Reset. If you have any more questions, feel free to upload a sample file to our forum and ask there: www.teachexcel.com/talk/microsoft-office?src=yt