After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
Excellent, I really appreciate your effort, Thanks A Ton Again :-) This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL . Very Unique way of teaching, Keep it up.
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos.. Excellent, I really appreciate your effort, Thanks A Ton Again :-) This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL . Very Unique way of teaching, Keep it up.
Very well explained Bro.. 👌 I'm not developer but what you want to tell at the end I totally understand... Thanks & keep going... Follow yoy from so long maybe this is my first comment.. I'm also computer faculty taught all this but thanks again... 🙏👌
I have seen your few videos in VB and must say that your teaching style is simple but comprehensively covers the contents. I am new to VB and want to learn the language step by step but have observed your videos do not appear in a sequential order. Is there a way I can access them according to the subject. Thanks
sir, can you please make deep lecture in VBA and SQL. I mean details of both to gain all knowledge relevant and your lecture very help full to us so easy to understand to VBA and SQL please sir, I hope you can doing well
Record Macro =========== 1)Open Balnk Sheet 2)Developer Tab ==> Record Macro ==> Use Relative Refferances ==> Record Macro 3)Record Macro Dialogue Box will Open ==> 4)Give Macro Name ==> Example)myColor 5)Give Keyboard Shortcuts ==> Shortcut key ==> Ctrl+Shif+A 5)Chhose Store Macro in ==> This Workbook 6) Description ==> Example) You make Color when run this Macro using Shortcut or Windows Screen 7)Recording has been Opened. 8)Now make Color in First Colum (A1) and then place the Cursor C1 9)Stop your Recording 10)Now Using Shortcut you can run Macro
Hi Pavan NIce Tutorial on Macros Recording..I want to create a macro which takes input from Sheet2 and adds some cells and the resulted value is displayed on Sheet1.
Dear sir, I went through your video on creating macro and I found it very well explained. I have a small difficulty as I am a beginner for macros. I want to create a macro to copy a part of text from one cell and append it to the text in another cell. How to go about this? Pl help.
Hi Mr,Pavan. Thank you so much for all the useful videos. I have tried to create a excel Macro as mentioned in this video. The coding was created like this.(Please look into "Range" at the end). Once I select Ctrl+Shift+A, at any cell, it Automatically lands on C1 cell. How to resolve this without editing manually, like given in your video. Thanks in Advance Sub Color() ' ' Color Macro ' This will color the Cells ' ' Keyboard Shortcut: Ctrl+Shift+A ' With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("C1").Select End Sub
Hi. After I colored A1 cell, I choosed C1 cell. But my macro didnt work like this video. When I run my code, was colored A1 cell but was choosen always C1 cell; not after 2 columns. How can I do🥲
Sir ek hi cell me likha he jese Tax Invoice- 4350 Hsn- 9001 Qty- 500 @ 25/- Hsn- 7015 Qty- 454 @ 670/- Ese karke bahut sare cell me likha jisme invoice no. Sabke alag hen hsn no. Alag alag hen bahut tarah ke hsn hen me chahta hu ke pura cell color full n ho jese mere hsn 9001 ke only text ka color hi change ho pure cell ka ni 9001 jaha jaha likha ho uska text green ho jaye 7015 ka red ho jaye 9015 ka blue ho jaye kya esa ho sakta he if yes to plz mujhe batayen
with help of your video, I learn how to record a basic macro when I'm closing the file I'm unable to run the same micro. please help me out how to run macro open the file.
Lakshmi, When you save the file you need to save it by extension .xlsm ( not .xlsx). .xlsm means macro enabled workbook. So this will save macro forever.
When a data is entered in one Excel sheet on a particular date, it should automatically be entered in another Excel sheet. Is there any formula for that?
@@sathishs9962 RUclips comment section is not an ideal forum to understanding Query, share Solution. Hence, please contact Me on goodnessshallprevail@gmail.com with Query and all relevant details before We explore Solution. Thank You!
This kind of macro is working for same sheet. But If you want to do it with another sheet, it's not working. Is there any way to record micro permanently.
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Sir if we want to learn macro in another sheet how is that possible for us to record
You are the best excel tutor I found in last 5 years...
What ever the topic you choose you are giving 💯% expected answers
Love you and your videos bro thank you!!!
Congratulations Sir 🎉
Your video used in excel virtual internship through JP Morgan Chase & Co. 😅
You are an asset Sir. The way you taught is just fabulous.
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
Nice explanation, the people who dnt know the basic about macro can understand by watching this video,it helped me alot thk u
You are very articulate in teaching
Hatsoff to you
Excellent, I really appreciate your effort, Thanks A Ton Again :-)
This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video
Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL .
Very Unique way of teaching, Keep it up.
All your explanations were very clear and easy to understand. You are a great teacher
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
Excellent, I really appreciate your effort, Thanks A Ton Again :-)
This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video
Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL .
Very Unique way of teaching, Keep it up.
Coming in clutch rn I have to make a macro and function sheet for my final and these videos are helping a lot!
Thank you so much for explaining it in a very clear way I could learn the first simple macro now Thanks a lot again
Master in teaching skill .. amazing ❤🎉🎉
It feels live with this kind of presentation.
I have found another excellent teacher after kuduvenkat
I freaking love you man, keep it up!!!!
just an appreciation comment....you really saved me tysm...idk how to express it but tysm.
I really appreciate the work u do bhai... Bas just a request if u could make a whole vdo of the set i. e.. VBA.. that would b of great help bhai...
Your video regarding Excel & VBA are very helpful for learners
Thank you soo much
Great job
very well explained from basics, Thank you
OMG.! Wonderful Mr.
Your way to teach ..is amezing..I learn macro so quick from your video... Thank-you so much!
Thanks alot ....I informed & share your tutorials link to my all students to learn it better...
Your explanation is amazing, what a claryity... I became your fan👌
Very well explained Bro.. 👌 I'm not developer but what you want to tell at the end I totally understand... Thanks & keep going... Follow yoy from so long maybe this is my first comment.. I'm also computer faculty taught all this but thanks again... 🙏👌
I am really impressed the way you are explaining.
I have seen your few videos in VB and must say that your teaching style is simple but comprehensively covers the contents. I am new to VB and want to learn the language step by step but have observed your videos do not appear in a sequential order. Is there a way I can access them according to the subject. Thanks
sir, can you please make deep lecture in VBA and SQL. I mean details of both to gain all knowledge relevant and your lecture very help full to us so easy to understand to VBA and SQL please sir, I hope you can doing well
Very nice ,clear and easy lesson about macros
I love the way u explained... Really thanks 🙂
very good teaching method sir!! simple and to the point !!!!!!!
very very helpful sir, hats of you for free education for our student
Nice super class sir.simple understand. Voice and explain action.super
U r awesome sir.
Plzzz make a video on PowerPoint macro feature
nice presentation sir
thanks a lot sir for teaching and cooperation
Very nice sir
Thanks for making me understand the macro.. in an easiest way. Thanks a lot teach like speaking curser on the computer screen 😉
Nice way of explaining
Sir
Good job and excellent teaching
Great presentation.
Super Sir
Excellent teaching
Nice teaching easy to understand
Superb presentation
Crisp and clear
Thank you Sir..Please also help ,how to write macros with if function to identify text in cell.
Thank you soooooo much sir, you're amazing please continue to do so.
Great sr thanks very much !😁😁😁
excellent give knowledge .... have you learn of macro coding? Pl confirm
Very clear.....good
Very simple and awea
Thank you so much
Record Macro
===========
1)Open Balnk Sheet
2)Developer Tab ==> Record Macro ==> Use Relative Refferances ==> Record
Macro
3)Record Macro Dialogue Box will Open ==>
4)Give Macro Name ==> Example)myColor
5)Give Keyboard Shortcuts ==> Shortcut key ==> Ctrl+Shif+A
5)Chhose Store Macro in ==> This Workbook
6) Description ==> Example) You make Color when run this Macro using Shortcut or
Windows Screen
7)Recording has been Opened.
8)Now make Color in First Colum (A1) and then place the Cursor C1
9)Stop your Recording
10)Now Using Shortcut you can run Macro
Hi Pavan NIce Tutorial on Macros Recording..I want to create a macro which takes input from Sheet2 and adds some cells and the resulted value is displayed on Sheet1.
Great explanation
Clear explaination..👍👍👌
Very good
Dear sir,
I went through your video on creating macro and I found it very well explained. I have a small difficulty as I am a beginner for macros. I want to create a macro to copy a part of text from one cell and append it to the text in another cell. How to go about this?
Pl help.
Thank you Sir
Hi Mr,Pavan. Thank you so much for all the useful videos. I have tried to create a excel Macro as mentioned in this video. The coding was created like this.(Please look into "Range" at the end). Once I select Ctrl+Shift+A, at any cell, it Automatically lands on C1 cell. How to resolve this without editing manually, like given in your video. Thanks in Advance
Sub Color()
'
' Color Macro
' This will color the Cells
'
' Keyboard Shortcut: Ctrl+Shift+A
'
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("C1").Select
End Sub
Your my favourite ☺️
Very clear,, thank you so much
Thanks so much...
Really very nice..keep it up bro
thank you
Prior to explaining what macro is and how it works. You should tell everyone that where from you get the developer tab.
thanks a lot sir.
Very helpful
Thanks, very well explained.
ruclips.net/video/4bT2TtjK1GM/видео.html
I did exactly same but a error dialog box came after I gave the command Ctrl+Shift+A, why ?
Wonder full program
How screen at back is operated by touching the screen
Whether pivot table can be recorded in Marco??
May I know which display device Sir is using?
Is it possible to create a CSV file through macro for a particular row or column?
thank you sir😘😘😘😘😘😘
very nice.
Is it applicable for excel formulas like vlookup
Brother your Tutorials helps me lot
🙏
Directed From JP Morgan Chase co Excel
Sir witch screen use
Hi Sir, How can I learn Macro from you.. Is there any online class going on.. Kindly let me know
Is it possible to do multiplication and division in same macro.
Very nice ..but while doing practically,for shortcut shift not working
Hi. After I colored A1 cell, I choosed C1 cell. But my macro didnt work like this video. When I run my code, was colored A1 cell but was choosen always C1 cell; not after 2 columns. How can I do🥲
Is it possible to create a multiple CSV files through macro ...?
thanks sir....
u well done
How to use this macro in another excel sheet
How to do permutations and combinations in ms excel sir pls make one video pls
Sir ek hi cell me likha he jese Tax Invoice- 4350 Hsn- 9001 Qty- 500 @ 25/- Hsn- 7015 Qty- 454 @ 670/-
Ese karke bahut sare cell me likha jisme invoice no. Sabke alag hen hsn no. Alag alag hen bahut tarah ke hsn hen me chahta hu ke pura cell color full n ho jese mere hsn 9001 ke only text ka color hi change ho pure cell ka ni 9001 jaha jaha likha ho uska text green ho jaye 7015 ka red ho jaye 9015 ka blue ho jaye kya esa ho sakta he if yes to plz mujhe batayen
thanks bro
can you help me to to find out %increase or %decrease of live data which is updated every minute....?
with help of your video, I learn how to record a basic macro when I'm closing the file I'm unable to run the same micro. please help me out how to run macro open the file.
Lakshmi,
When you save the file you need to save it by extension .xlsm ( not .xlsx).
.xlsm means macro enabled workbook.
So this will save macro forever.
this trick of adding color is working but when i undo it undo is not working color of cells still remains same
When a data is entered in one Excel sheet on a particular date, it should automatically be entered in another Excel sheet. Is there any formula for that?
Hi Sathish,
Yes, this can be done.
Please contact Me on goodnessshallprevail@gmail.com.
Thank You!
Hi. This is Mr Sathish. You have told that my query is possible. Could you kindly guide me?
@@sathishs9962
RUclips comment section is not an ideal forum to understanding Query, share Solution.
Hence, please contact Me on goodnessshallprevail@gmail.com with Query and all relevant details before We explore Solution.
Thank You!
I'm having very low sound issue. Can the volume be increased please?
This kind of macro is working for same sheet. But If you want to do it with another sheet, it's not working. Is there any way to record micro permanently.
Same question here
you click on "all work sheets"
Are you Cris cross from movie kai Po Che
Magic!