Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros

Learn the basics of visual basic (VBA) programming for Excel spreadsheets with this series of 4 videos.
Watch all of Tiger's Excel VBA tutorials in this playlist:
tinyurl.com/huc56j2
Also check out our Excel VBA for Post-Beginners series, where we apply code to an everyday task:
• Excel VBA for Post-Beg...
🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know
tinyurl.com/yc7jlmbs
Get in touch with us online, we would love to hear from you.
/ tigerspreadsheetsolutions
/ tigspreadsheets
tigerspreadsheetsolutions.co.uk/

[@Rasmuskvejborg]

I really appreciate he doesn't waste 10 seconds on saying welcome + what the title just said, like 100% of tutorials on youtube.

[@TigerSpreadsheetSolutions]

Thank you - and yes, I try to get on with it! Do check out the other videos on the channel.

[@indiaprona6991]

I completely fell in love with you. Seriously! Best programming teacher ever. Thank you from Argentina.

[@elliott8175]

Fantastic. 'Great teacher: very clear and highlights the first important points!

[@KKaro1]

Hey, I have been following a lot of Excel Guru's out there but none of them have explained that well especially with VBA and macros. Your tutorial is simple and short. Thank you so much. Your fan in Papua New Guinea

[@TigerSpreadsheetSolutions]

Thank you very much and welcome - do check out the other videos on the channel

[@monitoring_evaluation]

I am greeting a feel that this will be the best VBA teacher I've come across on YouTupe... I'm enjoying it already. Thank you so much for the wonderful first video. I watched a lot of videos and none of them takes time to explain the basics.

[@TigerSpreadsheetSolutions]

Thank you my friend and welcome to the channel! The basics are so important ...

[@jenkins5265]

This is excel! Way better than most of the other popular Excel VBA videos out there. Easy to understand and provides context for the actual coding.

[@TigerSpreadsheetSolutions]

+Jiji thanks Jiji! Check out the other coding series too :-)

[@abdirahmanhassan5959]

Amazing explanation... I wish all the teachers could explain like u ...Thank u very much.

[@antonstrydom3928]

Absolutely loved this series. Thank you for this. Started learning recently but still strugging to understand the meaning of some commands.

[@TigerSpreadsheetSolutions]

Keep at it, Anton!

[@powerstar817]

Finally i had finished until custom navigation video (around 21 videos) and even i can do this pretty good until now as i had practiced good and done without watching the videos AGAIN and im doing well Thank you so much TIGER SPREADSHEET SOLUTIONS for the practical way of teaching!! really superb :-)

[@TigerSpreadsheetSolutions]

Well done Vijay! Plenty more videos to come this summer so keep an eye on the channel...

[@DrSm4rT]

End of 2019. I feel like this is so valuable from the perspective of an absolute beginner. Thank you!

[@TigerSpreadsheetSolutions]

Thank you for watching - a welcome to the channel!

[@sahebazkazi8217]

I done all 4 tutorials without any error and with great understanding Thank you so so muccchhhh.

[@TigerSpreadsheetSolutions]

Good job, and good luck with the other VBA videos!

[@wongpaksum]

I just love it, thanks so much. I'm having an interview tomorrow which needs me to know VBA, and I was struggling until I saw your video

[@TigerSpreadsheetSolutions]

Hi there - thank you and good luck with the interview!

[@Wed_Keren]

Very Good! You make it so simple easy to understand

[@soujanyaguda5451]

Yeah !! I created my first button ..... Thanks Tiger :)

[@mezianeremila454]

Great teaching skills, you remind of a facilitator I had few months back, I'll definitely have a look at the rest of the series...

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel

[@freestyleethio7570]

@Tiger Spreadsheet Solutions !! Thank you so much for this great video. I just came across your channel today and watched 10 different videos until midnight. You solved my years frustration in just few hours. I just can’t thank you enough. You deserve a million likes!!!!!

[@TigerSpreadsheetSolutions]

Really great to hear, thank you so much!

[@MoSylla45]

Thank you. The measure of ability is how easy people understand what you are saying. This is very easy to understand.

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel

[@joyt7181]

Thank you. It is a fun learning :D. I created several buttons with cute messages from my kids and it makes me soooo happpyyyyy!

[@TigerSpreadsheetSolutions]

+Joy Tikoalu Good to hear you're having fun Joy! Your kids will be coding too, very soon ;-)

[@maras1077]

Thank you very much! it's so simple to understand. And so helpful!

[@TigerSpreadsheetSolutions]

Thanks Mara - good luck with your coding :-)

[@chrisginoc]

Just gotta say, as probably everyone has already said, amazing spot on presentation. Great job man.

[@TigerSpreadsheetSolutions]

Many thanks Chris - good luck with your VBA learning.

[@RVD_Gaming]

Finally an understandable video for true beginners... thank you very much!

[@TigerSpreadsheetSolutions]

You're very welcome Mr / Ms Jones. Keep coding!

[@mathteacher2651]

Very Good start! Thank you!

[@azeemazeem755]

Thank you so much for teaching this. I think VBA is very tough work before seeing your videos. But you teaching this simple. I try it with out errors .

[@TigerSpreadsheetSolutions]

Great to hear Azeem - do check out the other videos on the channel

[@gabif7]

You are a life saver I've been struggling to find vba and you saved me thank you so much!

[@TigerSpreadsheetSolutions]

Good to hear - do check out the other videos

[@videoart1496]

Finally a really well explained tutorial for beginners. Thanks

[@TigerSpreadsheetSolutions]

Welcome to the channel - do check out our other videos

[@linda6811]

Even for me (The Hague, The Netherlands) it was easy to follow your instructions. Thank you so much!

[@TigerSpreadsheetSolutions]

Good to hear Linda, I hope you can work through the whole series, and our VBA for beginners playlist.

[@Exceltrainingvideos]

Superb. To the point and crystal clear!

[@TigerSpreadsheetSolutions]

Glad you found it helpful!

[@abbyd254]

Thank you so much! I'm taking a class where the professor knows so much she doesn't remember how much we might not know, and this is a VERY helpful video for catching me up :D

[@TigerSpreadsheetSolutions]

Thanks Abby and welcome to the channel! Do check out some of the other videos.

[@iClone316]

Abby, that's my biggest complaint about most people who attempt to train or teach - they don't seem to have a solid understanding of what foundations we need to learn in order to understand what they're trying to say. I'm liking this video series so far. It teaches the basics.

[@lisaxx8556]

Hey man, thanks for creating this video. Been looking for a vid that'll help me start my macro journey. You're the best!

[@TigerSpreadsheetSolutions]

Welcome, Lisa!

[@Jeszreel]

Thank you and I love you!

[@nicolasblaszczyk8511]

Great lesson. Thank you.

[@thatotherguy4245]

excellent tutorial, thank you

[@dorissweanapo9860]

This is the first time I use VBA and I just enjoy to create my first button :)

[@atsporty]

Amazing way of teaching. Simplifies everything

[@TigerSpreadsheetSolutions]

Very kind of you to say - the concepts are essentially simple, because a computer has to understand them. Good luck.

[@marysidor5736]

Thank you! You made this easy and non-frightening. My goal is to use code for scientific calculations at work and the macros will make it easy for end level users. I look forward to more of your instructions.

[@paulchiporombe5413]

Amazing lesson, subscribing here needs no thinking. Thank you very much.

[@TigerSpreadsheetSolutions]

A big welcome to the channel, Paul!

[@cassondrad2280]

Awesome, You're "clear and concise". You move slow enough where I don't have to keep hitting stop, then I work my code and push start again. Highly recommend. Thank you

[@TigerSpreadsheetSolutions]

Thank you Cassondra! Do share with somebody whom you think might benefit.

[@tompendrey5713]

Great introduction video. I'm an engineer and have wanted to learn how to write macros for ages! Thank you.

[@TigerSpreadsheetSolutions]

Great to hear Tom - enjoy the rest of the videos on the channel and let me know how you get on 👍

[@iqbalhediananda3540]

excellent !!!

[@tukaramsankpal4090]

amazing and simple technic, most important best technic to teach someone......great teacher...👌👌👌👌

[@TigerSpreadsheetSolutions]

Many thanks - the simple techniques are the most powerful and in my view, the most important

[@JUANRAMIREZ-cg3ny]

By far one of the best VBA Excel videos for biginers, well done

[@TigerSpreadsheetSolutions]

Thank you Juan and welcome!

[@ratheesingh]

Very clear Tutorial. Excellent coaching. Thank you so much

[@phdone4146]

Thanks for a clear and easy intro to VBA!

[@TigerSpreadsheetSolutions]

It's a pleasure and welcome to the channel!

[@deepafrancis5148]

I love how you were to-the-point and didn't drag the conversation..need more tutors like you

[@TigerSpreadsheetSolutions]

Many thanks Deepa. I do drag things out a little more in other videos though :-/ thanks for the comment and good luck with your coding.

[@deepafrancis5148]

@@TigerSpreadsheetSolutions can you give a tutorial on searchable drop down list in Excel?

[@TigerSpreadsheetSolutions]

@@deepafrancis5148 Check out our Excel Userforms for Beginners series which has an example of a dropdown list in a userform - this may help. Good luck.

[@deepafrancis5148]

@@TigerSpreadsheetSolutions I have another query. When I convert an excel file into csv, there are some format mismatches happening. Eg: the cell with data "An_Example" gets copied over to the csv as "An _Example". please note the space which got added between the word An and "_". How do I resolve this?

[@jakeoliha3795]

I once told my lecturer that there is a possible way to run VB in Excel though, but i had no clue how, he laughed at it. Well i got proof now. Thanks a mill* sir.

[@TigerSpreadsheetSolutions]

+jake oliha Thanks Jake - hope it is the start of your coding career! I am sure your lecturer taught you lots of good stuff too :-)

[@alemdelic6235]

My first step is successful ... Thanks a lot :) God bless you !

[@TigerSpreadsheetSolutions]

Thank you, and good luck with the rest of your coding journey!

[@swagata79]

Wow, Thats a cool class!

[@muhammadefathy4845]

Amazing explanation.Thank you very much and appreciated

[@TigerSpreadsheetSolutions]

Thanks Muhammad and good luck with your VBA!

[@ellenshen2152]

Amazing!!

[@janemjane100]

it is super helpful! Please go ahead with what you are doing. Super clear explanation

[@TigerSpreadsheetSolutions]

Thank you, Jane!

[@claudiarinderknecht]

Great Tutorial, you helped me a lot - Thank you very much!

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel

[@mureagabriela4175]

great tutorial.very clear and helpful! thanks

[@knfdaily6333]

Good tutorial

[@OthmanAlikhan]

Thanks for the video, it was very helpful =)

[@shreecomputers1959]

Very Simple & Easy you stated here Fantastic

[@TigerSpreadsheetSolutions]

Many thanks - hope it is a good starting point for you

[@tallswar]

fabulous, clear and simple

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel!

[@mauriciomunozortiz]

From Connecticut , new England. Thanks for the video

[@TigerSpreadsheetSolutions]

Good to hear you are watching :-)

[@Personnenenparle]

i programm python, arduino, and google sheets.. glad there is sucha quick guide to get started. thank you!

[@TigerSpreadsheetSolutions]

Glad it helped and welcome to the channel - do check out the other videos :-)

[@a.rahmanalthawadi7411]

Thank you!

[@karladuenas441]

Very well explained! Thank you!

[@TigerSpreadsheetSolutions]

It's a pleasure, please check out the other videos on the channel

[@mairsee7420]

Great tutor👍🏻, the presentation is clear and practical.

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel - do check out the other videos.

[@chinthaka22]

Sending wishes from Sri Lanka to continue with this great teaching

[@TigerSpreadsheetSolutions]

Thank you for the lovely comment!

[@bonez8246]

Top man well informed easy to understand..Thanks for sharing knowledge is Power.!!!!!

[@TigerSpreadsheetSolutions]

Could not agree more Mo - good luck!

[@msofficiallove]

Very well explained :)

[@aynakatibova7127]

Thank you!!

[@martinzieikjenogeenkeer8620]

Thanks for the clear explanation !

[@TigerSpreadsheetSolutions]

You're welcome Martin - please check out the rest of our VBA tutorials. Good luck!

[@foodparadise5792]

Taking numerical methods for chemical engineering and required to learn Excel VBA. I was totally clueless about excel let alone VBA prior to this video... Thanks for showing the basic stuff...

[@TigerSpreadsheetSolutions]

You're welcome - bear in mind that it's best to learn basic Excel before getting too far into VBA - good luck!

[@tanvirparvez3364]

Thanks a lot man.. It's very helpful

[@TigerSpreadsheetSolutions]

+Tanvir Parvez You're very welcome Tanvir - good luck with the VBA

[@jentran519]

kool !!! Thank you very much

[@Loanme5]

Too good to be true. Years of frustration and misunderstanding replaced by a meaningful understanding after one viewing of the beginner VBA videos. Thank you very much.

[@TigerSpreadsheetSolutions]

Ah - thank you. A lovely Christmas comment! Please do spread the word about the channel. Happy to hear the videos are helping people out there - remember there are plenty more on the channel :-)

[@allotehwillis4071]

Nice way of teaching beginners. Great video. God bless

[@TigerSpreadsheetSolutions]

Thank you for watching!

[@knfdaily6333]

Amazing explanation... I wish all the people could explain like u

[@drm2566]

Great video, nice clear speech, kindly Dean Australia

[@TigerSpreadsheetSolutions]

Thanks Dean and good luck with your coding down under!

[@anthonyover]

Very clear. Thank you.

[@TigerSpreadsheetSolutions]

You're welcome - please check out the other videos on the channel

[@lukemeyers8741]

Good teacher. Explains it well.

[@TigerSpreadsheetSolutions]

Many thanks Luke and a big welcome to the channel

[@omar_Abd_Alrazzak]

Thank you, it's so helpful

[@TigerSpreadsheetSolutions]

You're welcome Omar!

[@hotboyphil]

nice and clear thanks

[@sonjar0040]

Great teacher! Thanks a lot!

[@TigerSpreadsheetSolutions]

You're welcome - please check out the other videos on the channel

[@melissad3390]

Your video is art: explained beautifully.

[@TigerSpreadsheetSolutions]

Thank you so much Melissa!

[@ahmedezzat4194]

Very simple teaching ... thank you

[@TigerSpreadsheetSolutions]

Thanks Ahmed and good luck with your coding.

[@technicalstudies.]

Thank you.

[@budisantoso1526]

Loved this. Great

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel!

[@jezcmamun5996]

wish most videos are like this one. thank so much

[@TigerSpreadsheetSolutions]

Many thanks and good luck with your coding

[@AlexeyZubkov]

BTW Choose Tools ➢ Options to display the Options dialog box, ensure the Require Variable Declaration check box on the Editor page is checked, and then click the OK button to enable Option Explicit by default

[@TigerSpreadsheetSolutions]

Nice tip, Alex!

[@rjamparado]

Excellent tutorial!

[@TigerSpreadsheetSolutions]

Thanks Roy - please do check out the other coding videos on the channel

[@ms.vasquez1805]

Love the way you explain each task and you have a nice clear voice!!!!! I was in shock that I understood what I was doing as I followed you....unlike others you just so sassy and smooth at explaining. Kudos !!! 😁😁😁😁🤗🤗🤗

[@TigerSpreadsheetSolutions]

Many thanks Ms. Vasquez. - I've never been called sassy and smooth before but I will try to channel that in future videos! Please check out the other videos on the channel and good luck :-)

[@ms.vasquez1805]

@@TigerSpreadsheetSolutions Thank you very much😀. Yes, you seems to elaborate and demonstrate with good flow .( not too slow or too fast ) keep up great work... 👍👍👍👍👏

[@TigerSpreadsheetSolutions]

Plenty more videos to come...

[@mxrvxn08]

This is a begineer friendly. Thank you so much I learned alot

[@TigerSpreadsheetSolutions]

Welcome to the channel, Marvin!

[@rachidbeggar711]

Thank you so Much, It's very helpfull.

[@TigerSpreadsheetSolutions]

Thank you Rachid - please do share it with somebody whom it might help. Good luck with your coding.

[@thomasdoe6768]

You´ve earned a Sub, kind sir. Outstanding work!

[@TigerSpreadsheetSolutions]

Thank you Thomas! Do check out the other videos on the channel ...

[@rithdicken2765]

Thank you so much for your useful explanation

[@TigerSpreadsheetSolutions]

Thank you Rith - please spread the word about the videos!

[@mohamedkasim6544]

Really appreciate. Thanks

[@TigerSpreadsheetSolutions]

Welcome to the channel!

[@gig777]

Excellent video!

[@TigerSpreadsheetSolutions]

Glad you liked it!

[@Ally-sj6ue]

Excellent!! beautifully expained

[@TigerSpreadsheetSolutions]

Thank you Ally and good luck with your VBA :-)

[@Suasagesmonkey]

Brilliant

[@Sammy-xv7mq]

Good morning, Am new to VBA and am passionate of learning Thank you for that amazing video and the way explained it Will continue watching your videos and learn more about VBA

[@TigerSpreadsheetSolutions]

Thank you my friend and welcome to the channel

[@Sammy-xv7mq]

I did my first click button following your training So happy

[@TigerSpreadsheetSolutions]

Sammy awesome! 🔥

[@mblingam]

Super. Very Good teaching, every body can understand

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel

[@AC-qo8oq]

That was so much fun!

[@TigerSpreadsheetSolutions]

Thanks AC - good luck with your coding.

[@user-ll1ox7xq6x]

Well explained and made simple.

[@TigerSpreadsheetSolutions]

Thank you, Z!

[@tuanlong8641]

Oh GOD, i created the first button in my life! Thank you so much! :)))))))))))))))

[@TigerSpreadsheetSolutions]

Good job! The first of many, hopefully :-)

[@elliott8175]

Yes, it was the first for me too! =) Thanks Tiger.

[@peterveer7798]

Tiger Spreadsheet Solutions where can i find vba codes ?

[@kevinmorton6276]

This man is awesome thanks mate

[@TigerSpreadsheetSolutions]

Cheers Kevin - good luck with you VBA!

[@chefbain5031]

thank you....sir...not only learn but also I understand it so nicely

[@TigerSpreadsheetSolutions]

Thank you sir - please do check out the other videos on the channel