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?
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
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!
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. 🙏
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.
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.
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.
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
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....
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!
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... :)
Hi dear, I am trying to seatch for a way to connect database in which stored into SQL server and Excel table. For instance, when I have a change hit the data, what should I do is, to pull data from sql server into excel, then make the changr, afterthat writing back or store the data back into sqlserver database and so on
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/
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.
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!!
Hi Sir, I have question here. If I made the same fill_yellow_color tab and it is working fine. If I try it on another new sheet , it is not working. Where to save the Macro code so that it can work for every sheet? Thanks in advance
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..
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.
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?
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 ..
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
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
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
I hope someone can offer some advice. I am having a tough time with the VBA Editor. When entering code, if I type quickly, the code appears normally, but if I slowly type, the editor moves the cursor, inserts spaces and screws up the code. If I am touch typing and don't watch the text as I type, I get errors that I have to find and debug. For example: If I type test=50/43 quickly that text is exactly what shows up. If I type slowly, after I enter the digit 4, the editor moves the 4 to the right to insert a space between the slash and the 4 digit and when I hit the 3 the code looks like this. test =50 / 3 4. I like the "neat" code with spaces inserted for readability, but not to the point where the code moves around faster than I'm typing and causing errors. Help anyone? I am going crazy. I am using Office 365 on a MacBook Air M1. Thanks!
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??
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.
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)
@@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.
I am getting type mismatch error '13' run time error in the line"set neworksheet = sheets.add" i did everything same as said in the video could somebody help me with this
I wrote exactly your code and keeps saying the “Set pickedData = Selection” part is a mismatch. When i hover over it in yellow it just says “pickedData = Nothing” Im confused
@@chandoo_ yea I figured it out haha. Stupid mistake. Thanks for the help!! And also; i am currently an intern at a U.S manufacturing company doing some data analytics work and other exporting/logistical duties. Is there anyway I could get some help from you or ideas, tips, on improving my already completed workbooks using VBA? Id be willing to pay for your time ( hopefully it’s affordable, i have money but not that much lol )
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.
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/
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
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.
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!!
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"
Are you talking about a spreadsheet that you share with someone else, and you want to know if they’ve edited one of the cells? Would locking the sheet or just locking specific cells accomplish what you want? Otherwise I suppose you could keep a copy of the original and then write some code that will compare the original with the shared copy and highlight any differences.
Excel 365 offers more ways to collaborate and share files with colleagues. You can even open the file on Excel online and see who changed what in an instant. Bill (MrExcel) showed this the other day here - ruclips.net/video/oQSi0I16XlE/видео.html
please tell me what i am doing wrong i am follwing all your step in fill ywllow colour but but when i am clicking on the button its taking me back to the same cell and not performing the change in the selected cell
Hi Rishabh... This happens if you "select the cell" after hitting record button. Do it like this: 1. Select a cell 2. Hit record macro button 3. Fill color 4. Stop recorder.
Hi folks.. I just released PART 2 of this video. Check it out here ruclips.net/video/nerIcLV7a2s/видео.html and take your VBA skills to next level. 😃
u r the best
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?
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
Thanks Chandon. Basically VBA replaces macro?
Thanks for this vedio🎉
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!
thanks chandoo i just viewed this video
this is the simplest way to learn VBA
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. 🙏
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.
Chandoo. Excellent, your coaching is as good as an adult teaching a child how to ride a bicycle. Gudos.
Actually I m speechless now Sir....🙏
but U have a very beautiful voice and ur intelligence is another level
He is so calm /subtle man ..
😘😘😘🙏what could be better than lerning from a successful, inteligent and professional MAN...
Wow marvelous!
I liked ur language very much and understood everything without any doubt. Expecting more videos
Super presentation. Unlike other EXCEL presentation, this will open up a new world for those who want to crack their head.
You should have more than 1crore subscribers considering your valuable content..you are amazing
Thanks for the love and blessings Anupam :)
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.
Thanks Anthony... I am glad you enjoyed this.
Hi Chandoo. Nice getting started video for VBA. Thanks for sharing :)) Thumbs up!!
You are welcome Wayne. :)
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.
Do you have any additional videos on specific Data Extraction, such as Data Entry forms. I am attempting to build a project calendar.
I mean wow, I never thought we can do something like this in Excel. Thank u so much for this video.
Explanation and Editing are another level, felt found good tutor
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
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....
I run an online course for this Shri. Check out chandoo.org/wp/vba-classes/ and sign up
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!
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... :)
Thanks Hussain... VBA certainly makes Excel more fun...
Great
Thank you sir... eagerly waiting for the second part of this video 😀😀👍
Thanks Naveen... Won't be long.
Thanks for sharing very helpful video and tips❤❤
your explination is so intresteing and simple chandoo
Guys he is not human. He is lying. He knows everything which feels sceptical. Please come from real id
Amazing sir. Did a great job!
Hi dear, I am trying to seatch for a way to connect database in which stored into SQL server and Excel table. For instance, when I have a change hit the data, what should I do is, to pull data from sql server into excel, then make the changr, afterthat writing back or store the data back into sqlserver database and so on
Chandoo! As always you presented a perfect bundle of information! 😎👍
Good Demonstration of VBA. Quite useful
You're really amazing Sir. Great explanations From Haïti
Wow and amazing knowledge Chandoo. Hats off
Thanks. Explained in a simple way.
You're welcome!
This is very good tutorial. Delivered with simplicity. Keep it up, Chandoo!
Hi sir please create vba vedio from basic to advanced vedio please sir it's my humble request to you
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/
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.
Very usefull information . Thank you.
Thnx Aparichit Sir
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!!
10:01 I am not getting to change the colour can someone help me out with this? please ? Great tutorial. Thank you
Many thanks Chandoo!! ❤️❤️
Chandoo Anna, I always like your video and learning.
Thanks Bhavani... :)
finished watching
Awesome video, thankful to land on your video.
finished practicing
Great explanation Thumbs Up.
Was it much easy 🤩
Can u show how the macros is working for date expiration with pop up
Awesome content!!!!
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.
Outstanding!
Thanks Jerry...
Do you have a tutorial wich shows how to extract data to another workbook on the computer that is not open?
Thanks chandoo… waiting for part 2 eagerly…
You are welcome Ashfaq... won't be long.
Thank you, very useful video.
How to filter out with multiple criteria for a column, could you please explain me
Finally sir u r on RUclips.
Thanks Vinod. I am here for over 11 years now. :)
Hi Sir, I have question here. If I made the same fill_yellow_color tab and it is working fine. If I try it on another new sheet , it is not working. Where to save the Macro code so that it can work for every sheet? Thanks in advance
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..
Loved the video. Thank you!
You are welcome Bikash.
Please explain deeply about compilers and interpreters...
Just loved it, sir. Thank you so much.
Most welcome!
@@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?
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.
Extremely Helpful
Wonderful! it is educative
Thank you, but macro is not assigning in my excel worksheet
Chandoo sabka bandhu
I encounter error in the first part,, in Fill color, the Marco botton, didn't do what I did.. I copy the files, from empty Excell then do the videos..
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?
Great job!
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 ..
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
@@chandoo_ Thank you Sir..
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
How amazing. Thank you
You are so welcome!
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
Looking for a tutor to learn VBA.
Preferred mode- offline, Delhi
Sir, how this help out an accountant in his career growth
Please show how to quickly track data entry skip
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 Thanks a lot
I hope someone can offer some advice. I am having a tough time with the VBA Editor. When entering code, if I type quickly, the code appears normally, but if I slowly type, the editor moves the cursor, inserts spaces and screws up the code. If I am touch typing and don't watch the text as I type, I get errors that I have to find and debug.
For example: If I type test=50/43 quickly that text is exactly what shows up. If I type slowly, after I enter the digit 4, the editor moves the 4 to the right to insert a space between the slash and the 4 digit and when I hit the 3 the code looks like this. test =50 / 3 4. I like the "neat" code with spaces inserted for readability, but not to the point where the code moves around faster than I'm typing and causing errors. Help anyone? I am going crazy. I am using Office 365 on a MacBook Air M1. Thanks!
Excelente 5 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️()
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??
Chandoo I texted some questions that i got error on VBA
Awesome dear
Hi..How to create a macro for automating an excel sheet body and send it through outlook
Please see this page - chandoo.org/wp/send-mails-using-excel-vba-and-outlook/
👌👌💯
Also explain VBA library?
Chandoo bro can you please give me the list of all vbs codes?
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.
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)
@@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.
Hello ... when reopen my excel file, macro is remove from file .. what should be the reason ??
You need to save your Excel file in "Macro Enabled" format to see the macros.
I am getting type mismatch error '13' run time error in the line"set neworksheet = sheets.add" i did everything same as said in the video could somebody help me with this
hmm.. looks like you have a typo in the variable name.
I wrote exactly your code and keeps saying the “Set pickedData = Selection” part is a mismatch.
When i hover over it in yellow it just says “pickedData = Nothing”
Im confused
Are you sure you have "selected" something in the worksheet before running the macro?
@@chandoo_ yea I figured it out haha. Stupid mistake. Thanks for the help!!
And also; i am currently an intern at a U.S manufacturing company doing some data analytics work and other exporting/logistical duties.
Is there anyway I could get some help from you or ideas, tips, on improving my already completed workbooks using VBA?
Id be willing to pay for your time ( hopefully it’s affordable, i have money but not that much lol )
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.
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/
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
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.
HI BOSS PLEASE CREATE VBA PLAYLIST ITS VERY USEFUL TO ALL EXCE ADVANCED USERS
There are many playlists on my channel. ruclips.net/user/ExcelTutorialsplaylists
Are you not satisfied with them? Do you want to anything specific?
Does anyone know how to read the table of contents on a CD using VBA?
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!!
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"
Stock market data fatching live form site exm---NSeindia etc guide video plz
See this for an example ruclips.net/video/VRLxcN_w-rg/видео.html
For Data extractor - if copy and paste has to be done with format and formulas- is it possible?
You can use recorder to see what additional pastespecial code is needed to copy format & formulas too.
Hello!
Is there any way (formula) to determine if the assigned cell for the users has been edited or touched? TIA :)
Are you talking about a spreadsheet that you share with someone else, and you want to know if they’ve edited one of the cells? Would locking the sheet or just locking specific cells accomplish what you want? Otherwise I suppose you could keep a copy of the original and then write some code that will compare the original with the shared copy and highlight any differences.
Excel 365 offers more ways to collaborate and share files with colleagues. You can even open the file on Excel online and see who changed what in an instant. Bill (MrExcel) showed this the other day here - ruclips.net/video/oQSi0I16XlE/видео.html
please tell me what i am doing wrong i am follwing all your step in fill ywllow colour but but when i am clicking on the button its taking me back to the same cell and not performing the change in the selected cell
Hi Rishabh... This happens if you "select the cell" after hitting record button. Do it like this:
1. Select a cell
2. Hit record macro button
3. Fill color
4. Stop recorder.
@@chandoo_ thank you sir
@@chandoo_ thanks for this chandoo, same problem, I quit because i don't understand definitely do it again,. Thanks😊
I love you
Chandooo😂😂😂