HomeОбразованиеRelated VideosMore From: Tutorials Point (India) Pvt. Ltd.

Excel VBA - Record a Macro

879 ratings | 115753 views
Excel VBA - Record a Macro Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Html code for embedding videos on your blog
Text Comments (41)
Mohammed Abdul Rahman (13 days ago)
in which city is your institute and can you give contact no
Omkar Darekar (20 days ago)
Hay can u please help me to learn macro, I am searching some books related to it plss suggest me
Qureshi Saddam hussain (1 month ago)
Ssssssuuuuuupppppppeeeeeeeeerrrrrrrrrrbbbbbbbbbb
Farhan Chodhary (1 month ago)
Wonder full program
M Kanagasabapathy (1 month ago)
Nice explanation
praveen kumar (2 months ago)
Really very nice..keep it up bro
Farjad Ali Saif (2 months ago)
I like the way he is teaching....
michioro64 (3 months ago)
Magic!
Nishant Naveen (3 months ago)
Great explanation
Nishant Naveen (3 months ago)
why we are using RELATIVE REFERENCES
Vikas Padale (3 months ago)
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.
Deepak Sharma 999 (3 months ago)
Very nice ,clear and easy lesson about macros
Maurice Lee (4 months ago)
very nice.
Gagana Shree (4 months ago)
Clear explaination..👍👍👌
alphons isac (5 months ago)
Superb presentation
What ever the topic you choose you are giving 💯% expected answers Love you and your videos bro thank you!!!
Your video regarding Excel & VBA are very helpful for learners Thank you soo much Great job
Hemant Bharankar (5 months ago)
very very helpful sir, hats of you for free education for our student
Vikrant Shah (5 months ago)
Very helpful
sachcha vishwakarma (6 months ago)
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 😉
spykat (6 months ago)
Nicely explained each topics, and you do not cheat while teaching and confuse the learners which most tutors do. They are unwilling to explain even after we enroll for the course(any course besides excel) and just read out the definition. They skip most important and vital topics in the course. But here, you have touched each minute detail and you are very focused. Some people requesting you to slow down the teaching speed but for me even if it is fast, it is understandable because you go step by step.
Pavan Lalwani (6 months ago)
Awesome buddy great. Thanks for the appreciating . Keep watching keep learning.
sarita singh (6 months ago)
thanks bro
Rose Formosa (6 months ago)
Excellent teaching
Arun Kumar (7 months ago)
Pahle se record kiye gaye macro records me macro me edit kaise kare gaye? Help
Pavan Lalwani (6 months ago)
Press Alt + F11, Window will open, and you can edit
AvengerArts (7 months ago)
I freaking love you man, keep it up!!!!
Lakshmi Narayana (7 months ago)
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.
Pavan Lalwani (6 months ago)
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.
TARUN SUKHPALANI (7 months ago)
I have Created a VBA PROJECT for Small Coaching Institutes and Computer Classes to manage the details of Student, their Attendance and Fees. If You are interested, You can Download it from...http://gpnow.in/excel
Bhavani Mopidevi (7 months ago)
Nice teaching easy to understand
Shamshad Ahmad (7 months ago)
You are the best excel tutor I found in last 5 years...
Ajay Anand (9 months ago)
I love this guy's detailing :)
Infinite Music Icons (9 months ago)
All your explanations were very clear and easy to understand. You are a great teacher
Lalit Gupta (9 months ago)
Sir aap tally bhi krvado plzzz,
Riyas GK (10 months ago)
Very clear.....good
KARTHICKRAJA M (10 months ago)
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
Lohit Manivasagam (10 months ago)
Why we should select use relative reference? Could'nt understand its role...
Pavan Lalwani (6 months ago)
This is related to Excel Cell referencing (Relative reference & Absolute Referencing)
vasanthi thangavel (1 year ago)
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..
Abhishek Jha (1 year ago)
Thanks, very well explained.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.