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
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.
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.
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.
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
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.
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.
Thanks Randhwa... Here is my VBA playlist - ua-cam.com/video/nerIcLV7a2s/v-deo.html I plan to add more VBA and programming videos in the coming months.
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
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... :)
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....
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 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 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 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.
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
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
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
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!!!
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?
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..
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
Hi folks.. I just released PART 2 of this video. Check it out here ua-cam.com/video/nerIcLV7a2s/v-deo.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🎉
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.
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.
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!
just because of you i wrote my first code, thank you chandoo
Woohoo!!! More Power to you ⚡
You are amazing, I loved how you explained each step so clearly, I was able to learn VBA without previous experience! Thank you!
thanks chandoo i just viewed this video
this is the simplest way to learn VBA
Brilliant Chandoo . Best tuition ive came across to date
Awesome Purna Chandra ! INDIA needs Teachers LIke you......
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.
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.
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 ..
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.
😘😘😘🙏what could be better than lerning from a successful, inteligent and professional MAN...
Explanation and Editing are another level, felt found good tutor
You should have more than 1crore subscribers considering your valuable content..you are amazing
Thanks for the love and blessings Anupam :)
Chandoo garu
Thank You Sir 🙏
ధన్యవాదాలు💐
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. :)
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.
Thanks Randhwa... Here is my VBA playlist - ua-cam.com/video/nerIcLV7a2s/v-deo.html
I plan to add more VBA and programming videos in the coming months.
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
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
your explination is so intresteing and simple chandoo
Amazing sir. Did a great job!
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❤❤
Excellent teach sir please upload data analyst real time projects please please please please please
Chandoo! As always you presented a perfect bundle of information! 😎👍
Very clearly explained. Thanks.
Thanks a lot for this video ....
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
Wow and amazing knowledge Chandoo. Hats off
You're really amazing Sir. Great explanations From Haïti
Thanks. Explained in a simple way.
You're welcome!
Many thanks Chandoo!! ❤️❤️
Awesome video, thankful to land on your video.
Good Demonstration of VBA. Quite useful
You are amazing!
Wow, thank you! You are awesome too :)
This is very good tutorial. Delivered with simplicity. Keep it up, Chandoo!
u r superb, u r self less and super helpfull
Very usefull information . Thank you.
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.
Great explanation Thumbs Up.
You simply awesome!
Awesome content!!!!
Thank you, very useful video.
Chandoo Anna, I always like your video and learning.
Thanks Bhavani... :)
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!!
Loved the video. Thank you!
You are welcome Bikash.
Thanks chandoo… waiting for part 2 eagerly…
You are welcome Ashfaq... won't be long.
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.
Outstanding!
Thanks Jerry...
Thank You Sir, Awesome
Was it much easy 🤩
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?
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 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
Extremely Helpful
Wonderful! it is educative
10:01 I am not getting to change the colour can someone help me out with this? please ? Great tutorial. Thank you
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....
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.
Please explain deeply about compilers and interpreters...
Great job!
Finally sir u r on UA-cam.
Thanks Vinod. I am here for over 11 years now. :)
The painting job joke was funny
finished watching
finished practicing
17:36 chandoo from future 😜👍
Awesome as always
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
Can u show how the macros is working for date expiration with pop up
Do you have a tutorial wich shows how to extract data to another workbook on the computer that is not open?
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
In my org I need to send pivot to all suppliers through outlook
Kindly make a video about it chandoo sir plzzz
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..
How amazing. Thank you
You are so welcome!
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..
Great video! Thanks a bunch!!!!
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
Thank you so much
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!!!
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?
Thanks a lot Anna !
You are welcome 😊
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..
How to filter out with multiple criteria for a column, could you please explain me
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
Sir, how this help out an accountant in his career growth
Chandoo sabka bandhu
Thank you, but macro is not assigning in my excel worksheet
Awesome dear