Learn VBA & Excel Macros in 20 minutes - with code samples 👨💻
Ғылым және технология
VBA is a great entry-level programming language. If you have been looking for a solid, no-frills and practical guide to learn VBA, here it is.
In this detailed video,
* Learn what VBA is and how to find it in Excel?
* How to use recorder to record and replay Macros (steps or actions)
* How to write your own code using Visual Basic Editor (VBE)
* Making a simple to-do list app in Excel
* Creating a data extractor app in Excel
* How to self-learn VBA with recorder & help
Watch PART 2 here 2️⃣👉
====================
I just released a part of this video. Watch it here - • Take your Excel VBA sk...
SAMPLE FILE 👉
==============
files.chandoo.org/vba/getting...
Companion article + resources - chandoo.org/wp/excel-vba/
Online VBA Class for more - chandoo.org/wp/vba-classes/
Timestamps ⏱
=============
0:00 Introduction
1:20 VBA in Excel - where to find it?
2:40 A simple macro - coloring cells
4:55 Recalling the macro (adding a button)
6:30 Modifying recorded macro code (VBE)
10:26 To-do list application with VBA
18:37 Data extractor app with VBA
22:39 How to learn more VBA
Resources to learn VBA 📗💻💡
==========================
Companion article + resources - chandoo.org/wp/excel-vba/
My recommended Excel + VBA books - www.amazon.com/shop/chandoo?l...
Online VBA Class for more - chandoo.org/wp/vba-classes/
Playlists & Videos 📃🎥
====================
My VBA examples playlist - • Excel VBA Examples & P...
Introduction to conditional formatting video - • Introduction to Condit...
Got Questions 🤷♂️❓
=================
Post a comment so I can guide you.
* The amazon shop link uses my affiliate code.
Пікірлер: 192
Hi folks.. I just released PART 2 of this video. Check it out here kzread.info/dash/bejne/oJmmq8WFhprHYtY.html and take your VBA skills to next level. 😃
@ananyarajashekar5771
Жыл бұрын
u r the best
@kranthinagella7773
Жыл бұрын
in the VBA marking as complete, Had doubt that if task completed you marked as green and if by mistake you click on a task which was not completed as completed if you press the macro assigned button once again it will turn to cross mark, now what if later i completed the task how i can mark to completed with the code written it is not possible it seems. Can you please explain how to do that?
@kranthinagella7773
Жыл бұрын
Use the below code to turn the red mark again to green Sub Task_Marking() Range("b1:b25").Value = "Task is completed" If ActiveCell " " Then If ActiveCell.Offset(0, -1).Value = " " Then ActiveCell.Offset(0, -1).Value = 1 ElseIf ActiveCell.Offset(0, -1).Value = -1 Then ActiveCell.Offset(0, -1).Value = 1 Else ActiveCell.Offset(0, -1).Value = -1 End If End If End Sub
@sallyho146
Жыл бұрын
Thanks Chandon. Basically VBA replaces macro?
@kavitasalvi1132
Жыл бұрын
Thanks for this vedio🎉
I’ve watched sssoooo many videos trying to understand VBA. This has been the best because you actually explain what the coding verbiage means and represents.
@davidevans3199
Жыл бұрын
Do you have any additional videos on specific Data Extraction, such as Data Entry forms. I am attempting to build a project calendar.
You are a very good teacher. You actually give some confidence to novices. You are doing a novel and selfless job. Keep it up. God bless you. Be happy always.
You are amazing, I loved how you explained each step so clearly, I was able to learn VBA without previous experience! Thank you!
This is why VBA is very powerful in business process desktop spreadsheets automation. You just shown the BASIC of MACRO and the rest is WONDER. Great video tutorial. Awesome!
Big ups chandoo! I watched this video out of curiosity and I must say not only do you know your stuff, you are a great teacher as well. I wish I got clearer explanations like you're giving here during my programming lessons back in my university days. Keep up the good work.
Wonderful video Sir. VBA is a lot easier than SQL. You're awesome. Thank You so much. It's been a great day for me. Finally learned some cool stuff in Excel. 🙏
Super presentation. Unlike other EXCEL presentation, this will open up a new world for those who want to crack their head.
Brilliant Chandoo . Best tuition ive came across to date
Awesome Purna Chandra ! INDIA needs Teachers LIke you......
He is so calm /subtle man ..
Hello Chandoo. Just discovered your video. Great and easy to follow explanation. Thank you very much for covering all these topics in this tutorial. Great video
I mean wow, I never thought we can do something like this in Excel. Thank u so much for this video.
Chandoo! As always you presented a perfect bundle of information! 😎👍
thanks chandoo i just viewed this video this is the simplest way to learn VBA
Chandoo. Excellent, your coaching is as good as an adult teaching a child how to ride a bicycle. Gudos.
just because of you i wrote my first code, thank you chandoo
@chandoo_
Жыл бұрын
Woohoo!!! More Power to you ⚡
Actually I m speechless now Sir....🙏 but U have a very beautiful voice and ur intelligence is another level
Explanation and Editing are another level, felt found good tutor
This is very good tutorial. Delivered with simplicity. Keep it up, Chandoo!
Very clearly explained. Thanks.
Wow and amazing knowledge Chandoo. Hats off
Thanks for the good work you are doing, Please i would be very glad if you can do 2 hours full tutorials video on excel VBA program. Your teaching make me developed interest in excel VBA
Amazing sir. Did a great job!
You're really amazing Sir. Great explanations From Haïti
your explination is so intresteing and simple chandoo
Chandoo garu Thank You Sir 🙏 ధన్యవాదాలు💐
Good Demonstration of VBA. Quite useful
Many thanks Chandoo!! ❤️❤️
😘😘😘🙏what could be better than lerning from a successful, inteligent and professional MAN...
Great tutorial! Question though...I noticed when recording my macro when I selected a cell that had content inside, and then assigned the macro to a button and executed the button, it would jump to that cell. Some reason I had to start in a blank cell and then record the macro, then stop the recording and it worked like a charm! Thanks again! (3:46 is where I'm talking about). Cheers!
Extremely Helpful
Awesome video, thankful to land on your video.
Thanks for sharing very helpful video and tips❤❤
Thank you sir... eagerly waiting for the second part of this video 😀😀👍
@chandoo_
3 жыл бұрын
Thanks Naveen... Won't be long.
Hay Chandoo . doing very good job i learn aloooooot from your videos your way of teaching is clicked every mind , Your English is totally understandable as you speaks not in flout and even video editing is too cool none can lose interest . please keep it up and waiting for full VBA , Python course on youtube. Thanks buddy.
@chandoo_
2 жыл бұрын
Thanks Randhwa... Here is my VBA playlist - kzread.info/dash/bejne/oJmmq8WFhprHYtY.html I plan to add more VBA and programming videos in the coming months.
Thank you Chandoo, This is so easy, I learned excel macros and VBA many years back but, then never applied. I now try and test each of your lessons with my data. Excel is fun and Excel with VBA is a great fun to work with... :)
@chandoo_
3 жыл бұрын
Thanks Hussain... VBA certainly makes Excel more fun...
@ammadkangatabdulla8775
2 жыл бұрын
Great
Brilliant. In my case, I have to tick off not just a cell but a range of cells. Could anybody suggest what changes should I make?
Hi Chandoo. Nice getting started video for VBA. Thanks for sharing :)) Thumbs up!!
@chandoo_
3 жыл бұрын
You are welcome Wayne. :)
Very usefull information . Thank you.
u r superb, u r self less and super helpfull
Thanks. Explained in a simple way.
@chandoo_
3 жыл бұрын
You're welcome!
Awesome as always
Great as usual! I know VBA buy is great to see how an MVP Excel like you do it. I Always learn something new or improve my skills with you.
You should have more than 1crore subscribers considering your valuable content..you are amazing
@chandoo_
2 жыл бұрын
Thanks for the love and blessings Anupam :)
Thank You Sir, Awesome
Loved the video. Thank you!
@chandoo_
2 жыл бұрын
You are welcome Bikash.
Excellent explanation, you are really awesome. I missed your live on 25th June but later I have watched which is also awesome and very helpful for learning. Keep going for us Chandoo. To be honest it is really helpful for me as a HR Professional for last twenty five years.
@chandoo_
3 жыл бұрын
Thanks Anthony... I am glad you enjoyed this.
Great explanation Thumbs Up.
Thanks chandoo… waiting for part 2 eagerly…
@chandoo_
3 жыл бұрын
You are welcome Ashfaq... won't be long.
Thank you, very useful video.
Awesome content!!!!
Chandoo Anna, I always like your video and learning.
@chandoo_
3 жыл бұрын
Thanks Bhavani... :)
Wonderful! it is educative
Could you please create VBA full course (single course) / series of it, so to excel in it. Your videos are very helpful and teaching style is amazing. it's simple to understand. Thanx keep it up....
@chandoo_
2 жыл бұрын
I run an online course for this Shri. Check out chandoo.org/wp/vba-classes/ and sign up
Just loved it, sir. Thank you so much.
@chandoo_
3 жыл бұрын
Most welcome!
@tradingforliving6556
2 жыл бұрын
@@chandoo_ Hi sir.. Can we create a file as per customised data based on inputs and save in pdf format using Excel VBA by one click?
You simply awesome!
Great job!
Hi Chandoo. I really liked your tutorials but I have a question about the data extractor. What if we want multiple sets of data to be extracted? I believe the header will get copied each time we hit on the button. What would be the code setup if multiple selections have to be made without copying the header after the 1st selection. I am new to the VBA world and would appreciate more clarity on this!!
Thank you so much
Please explain deeply about compilers and interpreters...
Hi Chandoo Just saw your video where you created Data Extractor with VBA I found it very interesting However I do have one question about copying the headers. How can we make column range more dynamic Kind regards Eric Van Reck
Was it much easy 🤩
Outstanding!
@chandoo_
3 жыл бұрын
Thanks Jerry...
Sir, You are truly a great teacher. The way you introduced the macro and dive into VBA is so easy this helps viewer to learn more on any topic and your video editing was also excellent. May I know which software you use to edit your videos? Thanks for this video ..
@chandoo_
3 жыл бұрын
Thanks Arup.. I am using Camtasia for creating and editing my videos. You can check out my other video gear here - www.amazon.com/shop/chandoo
@arupmca
3 жыл бұрын
@@chandoo_ Thank you Sir..
finished practicing
How amazing. Thank you
@chandoo_
3 жыл бұрын
You are so welcome!
Love watching your videos. I am building NASCAR pool sheet which has hidden columns. I don't know how to use a macro to reset (clear) the date for the next year to start with a clean sheet and leave all formulas intact. Can you help
You are amazing!
@chandoo_
2 жыл бұрын
Wow, thank you! You are awesome too :)
Finally sir u r on KZread.
@chandoo_
2 жыл бұрын
Thanks Vinod. I am here for over 11 years now. :)
Thnx Aparichit Sir
Guys he is not human. He is lying. He knows everything which feels sceptical. Please come from real id
Pls tell which one more imp. VBA or Google App Script. Pls make video on it too....
10:01 I am not getting to change the colour can someone help me out with this? please ? Great tutorial. Thank you
Awesome dear
finished watching
Hi Chandoo, really like your videos about VBA. Excessing your videos from Papua New Guinea. My Question. I am trying to load tags to PI Process Book (PI SMT) but couldn't. Could you please show some light on this? Would really appreciate that.
Do you have a tutorial wich shows how to extract data to another workbook on the computer that is not open?
What would be the code for extracting Duplicate Highlighted Data into a new workbook sheet if you can do a video on that sir please.
Sir Thanks a lot
Thanks a lot Anna !
@chandoo_
3 жыл бұрын
You are welcome 😊
thanks for the video but i have one more question based on excel sum value if grater than budget should show in head line approved if less than budget should show rejected. how we can?
How to filter out with multiple criteria for a column, could you please explain me
Hi Sir, I have recently become a subscriber to the channel since your videos are always so educational and helpful. I do have a question - In an Excel sheet, I have 12 months in C1:M1 and monthly unit sold data for 5 customers from C2:M6. Is there a way to determine which customer starts selling in which month out of the 12 months? I do not want the results to spill as in FILTER function.
@chandoo_
3 жыл бұрын
Thanks for the sub. Interesting question. You can try INDEX(FILTER(), 1) to get first month when the unit sold is not blank. For example, this formula works. =INDEX(FILTER($C$1:$N$1,C2:N2""),1)
@nikunjparasrampuria6901
3 жыл бұрын
@@chandoo_ Thank You Sir. I shall try the same and get back to you. I am an aspiring business modeler and wish to ask you if you can create a series for business modelling? That would be really helpful Sir. Much love and support from India.
Does anyone know how to read the table of contents on a CD using VBA?
Chandoo your content is great. I have a very specific question about a xl spreadsheet ive made. Is there a way I can show it to you and ask you my question.
@chandoo_
3 жыл бұрын
Hi Joe.. thanks for that appreciation. You can email me your files, but unfortunately, I have a rather full plate of work and my turn-around time is 3-4 weeks. If you have specific Excel / VBA questions, you should post them in a forum or Stack Overflow for better results. My email is here - chandoo.org/wp/contact/
Excellent. But one query? The new sheet gets added before the active sheet. Is there any way to add the same after the active sheet. I have tried - "Set newWorksheet = Sheets.Add After:=currentSheet". But not working. Any work around? Thanks in advance
Sir, how this help out an accountant in his career growth
Also explain VBA library?
Hi Chandoo, regarding the "To Do List" code, I would like to assign a macro which will alternate / switch between the values -1/0/1/-1/0/1 as the buttton is pushed. How could such a code be written? Thanks / good videos!!
@BryanLeandry
Жыл бұрын
If you want to cycle it, add another if then line. The first one should check if it's blank, if it's blank the value returned would be 1, the next line checks if it's a 1, and if it is a one then return the value 0, finally check if the value is 0, and return a value -1, but now to go back to the value of 1, you'd have to check if the value is -1, then return 1. This is how I would write it but I'm learning as well so there would probably be a shorter way which he mentioned as "homework"
Hi sir please create vba vedio from basic to advanced vedio please sir it's my humble request to you
@chandoo_
3 жыл бұрын
Hi Deepak.. this is that video. Not sure what you are asking for? I have part2 of this series coming up in a few days and there is a VBA playlist too. For something more intense, go for my online class - chandoo.org/wp/vba-classes/
@yashsomaiya8141
2 жыл бұрын
Hi. Visit Wise Owl Tutorials channel. It will cover everything from basic to advance. Trust me it is one the best channel you might have ever come across.
Please show how to quickly track data entry skip
On, BVA code , how to enable the guide on color when I put my mouse, the color code guide is not displaying on the screen.. I don't know how to see the guides..
I need help! I need to extract data but attach it to the same file every time, without losing the data I had previously extracted. How do I do it? Thank you!!!
Nice
Great video! Thanks a bunch!!!!
@chandoo_
2 жыл бұрын
You are so welcome!
Nice Learning Sir I have small doubt can you tell me how to copy data from sheet1 and paste special in sheet2 last row when i play the command it has to paste in last row of sheet 2
@chandoo_
2 жыл бұрын
Thanks Sridhar. Record a macro with the steps you need. See the recorded code and customize it based on the concepts covered in this video. All the best.
Hello sir, very simple video, yet -for the 1st macro- when i click on the button it just format the same cells we choose while recording the mac. Can you correct me ,what did I mess up, though i follow the same rules & tried a few times. HELP pls??
17:36 chandoo from future 😜👍
Excelente 5 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️()