Hi folks.. I just released PART 2 of this video. Check it out here kzitem.info/news/bejne/z5uor5eCj2mSZag 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🎉
@davidevans3199
Жыл бұрын
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.
@SanjayGore
3 жыл бұрын
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.
@freeliberalminds
2 жыл бұрын
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!
@lilyfullery4779
2 жыл бұрын
just because of you i wrote my first code, thank you chandoo
@chandoo_
2 жыл бұрын
Woohoo!!! More Power to you ⚡
@ariannayoutube
2 жыл бұрын
You are amazing, I loved how you explained each step so clearly, I was able to learn VBA without previous experience! Thank you!
@GhazaliConsulting
Жыл бұрын
thanks chandoo i just viewed this video this is the simplest way to learn VBA
@tonyheron8265
3 жыл бұрын
Brilliant Chandoo . Best tuition ive came across to date
@shaikusman536
3 жыл бұрын
Awesome Purna Chandra ! INDIA needs Teachers LIke you......
@surajdarokar1541
2 жыл бұрын
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. 🙏
@charlesawuahcobbinah1726
Жыл бұрын
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.
@MR-mw2vs
2 ай бұрын
Wow marvelous! I liked ur language very much and understood everything without any doubt. Expecting more videos
@BegurKailash
2 жыл бұрын
Super presentation. Unlike other EXCEL presentation, this will open up a new world for those who want to crack their head.
@zakeerrg3010
Жыл бұрын
Chandoo. Excellent, your coaching is as good as an adult teaching a child how to ride a bicycle. Gudos.
@nitishpradhan7375
Жыл бұрын
Actually I m speechless now Sir....🙏 but U have a very beautiful voice and ur intelligence is another level
@muskaaandhalla8187
2 жыл бұрын
He is so calm /subtle man ..
@wildtraveler7399
2 жыл бұрын
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
@butterflyinvites
2 жыл бұрын
I mean wow, I never thought we can do something like this in Excel. Thank u so much for this video.
@nitishpradhan7375
Жыл бұрын
😘😘😘🙏what could be better than lerning from a successful, inteligent and professional MAN...
@rambofriends
Жыл бұрын
Explanation and Editing are another level, felt found good tutor
@anupammishra1013
3 жыл бұрын
You should have more than 1crore subscribers considering your valuable content..you are amazing
@chandoo_
3 жыл бұрын
Thanks for the love and blessings Anupam :)
@p.arogyaraju5838
2 жыл бұрын
Chandoo garu Thank You Sir 🙏 ధన్యవాదాలు💐
@anthonyrozario2757
3 жыл бұрын
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.
@wayneedmondson1065
3 жыл бұрын
Hi Chandoo. Nice getting started video for VBA. Thanks for sharing :)) Thumbs up!!
@chandoo_
3 жыл бұрын
You are welcome Wayne. :)
@ctnrandhawa7019
2 жыл бұрын
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 - kzitem.info/news/bejne/z5uor5eCj2mSZag I plan to add more VBA and programming videos in the coming months.
@brightagbenyo678
2 жыл бұрын
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
@chanceyknows4445
11 ай бұрын
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!
@hussainakhtar1094
3 жыл бұрын
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
3 жыл бұрын
Great
@jinkasreenath8652
2 жыл бұрын
your explination is so intresteing and simple chandoo
@santhakumarnatarajan
3 ай бұрын
Amazing sir. Did a great job!
@naveenvp7390
3 жыл бұрын
Thank you sir... eagerly waiting for the second part of this video 😀😀👍
@chandoo_
3 жыл бұрын
Thanks Naveen... Won't be long.
@JavedAnsari-vba
3 ай бұрын
Thanks for sharing very helpful video and tips❤❤
@Cricketfobiashorts
2 ай бұрын
Excellent teach sir please upload data analyst real time projects please please please please please
@apwnew
2 жыл бұрын
Chandoo! As always you presented a perfect bundle of information! 😎👍
@FreeSpeech1959
2 жыл бұрын
Very clearly explained. Thanks.
@PritamPaul717
3 ай бұрын
Thanks a lot for this video ....
@shrirana1904
2 жыл бұрын
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
@QuantuMatrix
2 жыл бұрын
Wow and amazing knowledge Chandoo. Hats off
@Sebastien_Frederic
2 жыл бұрын
You're really amazing Sir. Great explanations From Haïti
@mohammedmukarram6689
3 жыл бұрын
Thanks. Explained in a simple way.
@chandoo_
3 жыл бұрын
You're welcome!
@Deedington
Жыл бұрын
Many thanks Chandoo!! ❤️❤️
@dhanushm3690
2 жыл бұрын
Awesome video, thankful to land on your video.
@hemanttrivedi898
3 жыл бұрын
Good Demonstration of VBA. Quite useful
@jas3.3.3
3 жыл бұрын
You are amazing!
@chandoo_
3 жыл бұрын
Wow, thank you! You are awesome too :)
@gmagcaling
2 жыл бұрын
This is very good tutorial. Delivered with simplicity. Keep it up, Chandoo!
@twoplusa2391
2 жыл бұрын
u r superb, u r self less and super helpfull
@aegeanorganicslemnos8311
2 жыл бұрын
Very usefull information . Thank you.
@frenan82
3 жыл бұрын
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.
@khurshidanwarnafees
2 жыл бұрын
Great explanation Thumbs Up.
@lookingforwardto
Жыл бұрын
You simply awesome!
@MartinezRBA
Жыл бұрын
Awesome content!!!!
@nirmalabolar1382
2 жыл бұрын
Thank you, very useful video.
@Mamtha7272
3 жыл бұрын
Chandoo Anna, I always like your video and learning.
@chandoo_
3 жыл бұрын
Thanks Bhavani... :)
@asifbhat1078
Жыл бұрын
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!!
@BikashKumar-pz8hc
3 жыл бұрын
Loved the video. Thank you!
@chandoo_
3 жыл бұрын
You are welcome Bikash.
@ashfaqahmed130
3 жыл бұрын
Thanks chandoo… waiting for part 2 eagerly…
@chandoo_
3 жыл бұрын
You are welcome Ashfaq... won't be long.
@platformengineering..671
3 жыл бұрын
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.
@jerrymiles7804
3 жыл бұрын
Outstanding!
@chandoo_
3 жыл бұрын
Thanks Jerry...
@elfridhasman4181
3 жыл бұрын
Thank You Sir, Awesome
@Vikas.Verma06
Жыл бұрын
Was it much easy 🤩
@imranurrahman8538
3 жыл бұрын
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?
@MdAsif-km9sx
3 жыл бұрын
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?
@mnesevati
23 күн бұрын
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
@technicaldata3227
3 жыл бұрын
Extremely Helpful
@abdulazizthaim8517
2 жыл бұрын
Wonderful! it is educative
@pawansai7905
Жыл бұрын
10:01 I am not getting to change the colour can someone help me out with this? please ? Great tutorial. Thank you
@sarwarayaanali272
Жыл бұрын
Thnx Aparichit Sir
@amritsinghania2722
Жыл бұрын
Guys he is not human. He is lying. He knows everything which feels sceptical. Please come from real id
@singhalmonica
3 жыл бұрын
Pls tell which one more imp. VBA or Google App Script. Pls make video on it too....
@michaelmoke5174
Жыл бұрын
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.
@sagarmathur3535
2 жыл бұрын
Please explain deeply about compilers and interpreters...
@joseluis7118
2 жыл бұрын
Great job!
@VinodKumar-ec5hu
3 жыл бұрын
Finally sir u r on KZitem.
@chandoo_
3 жыл бұрын
Thanks Vinod. I am here for over 11 years now. :)
@shamoonrizvi2766
Жыл бұрын
The painting job joke was funny
@sandipansarkar9211
Жыл бұрын
finished watching
@sandipansarkar9211
Жыл бұрын
finished practicing
@waleed0936
2 жыл бұрын
17:36 chandoo from future 😜👍
@SRCOMPUTEREDUCATION
3 жыл бұрын
Awesome as always
@JavedAnsari-vba
3 ай бұрын
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
@kiranasok
Ай бұрын
Can u show how the macros is working for date expiration with pop up
@hamedhabibi6289
Жыл бұрын
Do you have a tutorial wich shows how to extract data to another workbook on the computer that is not open?
@ericvanreck4686
Жыл бұрын
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
@blazinghotred8728
Жыл бұрын
In my org I need to send pivot to all suppliers through outlook Kindly make a video about it chandoo sir plzzz
@excellnewbie4988
2 жыл бұрын
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..
@binoythomas2974
3 жыл бұрын
How amazing. Thank you
@chandoo_
3 жыл бұрын
You are so welcome!
@arupmca
3 жыл бұрын
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..
@mikewashington4188
3 жыл бұрын
Great video! Thanks a bunch!!!!
@chandoo_
3 жыл бұрын
You are so welcome!
@briancowan2950
2 жыл бұрын
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
@ubaid25
3 жыл бұрын
Thank you so much
@Antonio-nk5mx
Жыл бұрын
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!!!
@chandrupoojary5638
2 жыл бұрын
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?
@bskrmusic3932
3 жыл бұрын
Thanks a lot Anna !
@chandoo_
3 жыл бұрын
You are welcome 😊
@excellnewbie4988
2 жыл бұрын
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..
@vikrampurohit3033
Жыл бұрын
How to filter out with multiple criteria for a column, could you please explain me
@vinayachandranr7233
3 жыл бұрын
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
@StockistNKB
2 жыл бұрын
Sir Thanks a lot
@wnenu114
3 жыл бұрын
Sir, how this help out an accountant in his career growth
@ravindragurao
2 жыл бұрын
Chandoo sabka bandhu
@asmajabeen2736
Ай бұрын
Thank you, but macro is not assigning in my excel worksheet
Пікірлер: 198