Free Excel VBA Course #5 - Writing your first VBA Macro Code

Рет қаралды 40,845

Күн бұрын

In this video, I will show you how to write for the first VBA macro in Excel. It will be a really simple macro where we will go to specific cells in the worksheet and enter some text in these cells.
This video will give you a hang of how to structure your VBA macros and a little bit of how object-oriented programming works
✅ Download File: bit.ly/vbacourse-5
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 41

@mommacare764 Жыл бұрын

THANK YOU SO MUCH. i was stuck, you rescued me in a short video, i didnt have to spend 2 hours watching and it was straight to the point

@user-qf2on8vv3l Жыл бұрын

Your leacture is really a life-changing effect.

@kuyakambo2327 3 ай бұрын

This channel deserves millions of subscriber❤❤❤

@kumarofrajesh 4 жыл бұрын

excellent Mr Sumit I am trying to learn VBA for last ten years but your concept is very easy to understand.

@SunilYadav_sky 4 жыл бұрын

ten years?

@grahambridges3830 4 жыл бұрын

'Thank you Sumit for your very thorough and clear presentation. My very sketchy knowledge of VBA has lots of potholes in it that I hope you will fill.

@mohamedtawansy7286 3 жыл бұрын

Thanks a million .......... you taught me exactly what i needed to know..... thanks again ....appreciated... Guys , please see this video ...it is awesome in case you need to know how to write the VBA in detail :)

@gorakhanathk5054 4 жыл бұрын

Thank you sir. Your explanation is very good and easy to understand. I am watching your Free Excel - Basic to advance, Power Query Course and now VBA Course and I am much impressed. Thanks once again and keep it sir.

@trumpexcel 4 жыл бұрын

Glad you're finding the courses useful!

@robbysandhu4425 3 жыл бұрын

1 year ago I joined classes in Gurgaon and found VBA learning extremely difficult to understand and then quit. While Joined i had a thing on mind that what is use of Macro .Now i started watching your videos and found VBA learning pretty enjoyable and the concept is crystal clear. Thanks Sumit. Kudos.

@marksmith8667 3 жыл бұрын

Thank you for your very clear and straightforward approach to teaching VBA.

@trumpexcel 3 жыл бұрын

Thanks for commenting Mark... Glad you found the video useful!

@user-ds7up1fi2y 2 жыл бұрын

Thank you Sumit. Great lesson. You are my favorite coding teacher since Bucky Roberts.

@Prashant-vj5xq 4 жыл бұрын

Thanks a lot Mr. Sumit, I never thought i would do this.....Great !!! Thanks for Sharing

@deepaklmakwana8096 2 жыл бұрын

Thanks Sumit! you made me more curious to learn VBA now. anyways I have been given challenge to learn this language in a very short time by my Organization so I decided to start my journey with your this Awesome series!! I hope I will be thanking you more in future endeavors!.

@nataliya336 4 жыл бұрын

thank you Sumit for the quality material and detailed explanation, i am absolutely new to the topic, learning from you a lot.

@kyreerylan8164 2 жыл бұрын

i know Im quite randomly asking but does anybody know a good website to stream new tv shows online ?

@rajeshshah6758 4 жыл бұрын

Thanks for the video tutorials Sumit. They are so easy to understand.

@moncia9835 6 ай бұрын

I really enjoyed this video. Thank you very much! 😊

@robbysandhu4425 3 жыл бұрын

Thanks Bro. Best explanation ever i found.

@mohanvaze1 2 жыл бұрын

Very well explained. Thank you

@businessnepal193 Жыл бұрын

Great Lession, Thank you

@SatishKumar-fg4mn 3 жыл бұрын

Very supportive...thank you so much

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@abhinaygarg7029 3 жыл бұрын

Thank you so much, It helped me a lot...

@trumpexcel 3 жыл бұрын

Glad the video helped!

@kasun2023 2 жыл бұрын

You are best to teach VBA

@JamesBond-qg5gx 4 жыл бұрын

Thanks a lot 🙏

@mono65 4 жыл бұрын

Thanks a lot Sumit for this masterpiece, I propose if you agree to add at 9:33 of this video the following code for a better cells content lisibility: Range("A1:B1").Columns.AutoFit. What do you think?

@sisterniveditaschool 3 жыл бұрын

Thanks sumit

@libaadem10 3 ай бұрын

thanks sir for everything, but why are sheets keep adding? can i stop sheets and do everything with only one sheet?. is it add worksheets instead of worksheet? or just teaching as the steps you did with every action? thanks again for your time and dedication

@jasonchen2591 4 жыл бұрын

good !

@user-kn4ly7ss4l 6 ай бұрын

can we record macro with both options of absolute and relative recording

@JamesBond-qg5gx 4 жыл бұрын

If we send the file to someone else and if he disable the macros it means that macros will not work ? For example if I protect the file thru macros and other things.

@edmonddantes1141 Жыл бұрын

Please help, I want to copy certain range of a single row as a line into another workbook and another set of range from the same row to another workbook as a new line next to the already paste data thereafter certain range from the same row as a new Line to another line into another workbook right after the first two row. Please confirm how would I write a vba code for that

@salawurasaq4090 2 жыл бұрын

Hi, please how can I download the excel files

@amitparma1895 2 жыл бұрын

Sir I need your help creating a macro.could you please help me

@arghyadutta9091 3 жыл бұрын

like it

@KaileshHambireIJ-G- 3 жыл бұрын

Thank you Trump excel for this wonderful series of Free VBA course. I am following your videos regularly for two reasons. One to increase my knowledge in excel and increase my English vocabulary. You have very fluent speech in English and that has impressed me a lot. We all learn Lot from you. Today you explained us about two excel format xls and xlsm. What if i get a file from a friend and if i want to write or run macros in that sheet for further automation, Do i need to save that sheet in xlsm format.

@trumpexcel 3 жыл бұрын

Thanks for the kind words :) You can run macros in an XLSX file, but if you want these to be saved while saving the workbook, you need to change the file format to .XLSM