Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros
Вставка
- Опубліковано 26 сер 2024
- 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/hu...
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/yc...
Get in touch with us online, we would love to hear from you.
/ tigerspreadsheetsolutions
/ tigspreadsheets
tigerspreadshee...
I really appreciate he doesn't waste 10 seconds on saying welcome + what the title just said, like 100% of tutorials on youtube.
Thank you - and yes, I try to get on with it! Do check out the other videos on the channel.
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
Thank you very much and welcome - do check out the other videos on the channel
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.
+Jiji thanks Jiji! Check out the other coding series too :-)
@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!!!!!
Really great to hear, thank you so much!
I completely fell in love with you. Seriously! Best programming teacher ever. Thank you from Argentina.
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 .
Great to hear Azeem - do check out the other videos on the channel
Thank you. The measure of ability is how easy people understand what you are saying. This is very easy to understand.
Thank you and welcome to the channel
Amazing explanation... I wish all the teachers could explain like u ...Thank u very much.
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
Hi there - thank you and good luck with the interview!
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.
Thank you my friend and welcome to the channel! The basics are so important ...
End of 2019. I feel like this is so valuable from the perspective of an absolute beginner. Thank you!
Thank you for watching - a welcome to the channel!
You are a life saver I've been struggling to find vba and you saved me thank you so much!
Good to hear - do check out the other videos
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 :-)
Well done Vijay! Plenty more videos to come this summer so keep an eye on the channel...
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.
+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 :-)
I love how you were to-the-point and didn't drag the conversation..need more tutors like you
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.
@@TigerSpreadsheetSolutions can you give a tutorial on searchable drop down list in Excel?
@@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.
@@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?
Finally a really well explained tutorial for beginners. Thanks
Welcome to the channel - do check out our other videos
I done all 4 tutorials without any error and with great understanding
Thank you so so muccchhhh.
Good job, and good luck with the other VBA videos!
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...
You're welcome - bear in mind that it's best to learn basic Excel before getting too far into VBA - good luck!
i programm python, arduino, and google sheets.. glad there is sucha quick guide to get started. thank you!
Glad it helped and welcome to the channel - do check out the other videos :-)
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
Thank you Cassondra! Do share with somebody whom you think might benefit.
Absolutely loved this series. Thank you for this. Started learning recently but still strugging to understand the meaning of some commands.
Keep at it, Anton!
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
Thank you my friend and welcome to the channel
I did my first click button following your training
So happy
Sammy awesome! 🔥
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
Thanks Abby and welcome to the channel! Do check out some of the other videos.
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.
Great introduction video. I'm an engineer and have wanted to learn how to write macros for ages! Thank you.
Great to hear Tom - enjoy the rest of the videos on the channel and let me know how you get on 👍
Amazing lesson, subscribing here needs no thinking. Thank you very much.
A big welcome to the channel, Paul!
Hey man, thanks for creating this video. Been looking for a vid that'll help me start my macro journey. You're the best!
Welcome, Lisa!
Even for me (The Hague, The Netherlands) it was easy to follow your instructions. Thank you so much!
Good to hear Linda, I hope you can work through the whole series, and our VBA for beginners playlist.
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...
Thank you and welcome to the channel
Thanks for a clear and easy intro to VBA!
It's a pleasure and welcome to the channel!
Just gotta say, as probably everyone has already said, amazing spot on presentation. Great job man.
Many thanks Chris - good luck with your VBA learning.
Sending wishes from Sri Lanka to continue with this great teaching
Thank you for the lovely comment!
By far one of the best VBA Excel videos for biginers, well done
Thank you Juan and welcome!
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.
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 :-)
fabulous, clear and simple
Thank you and welcome to the channel!
Fantastic. 'Great teacher: very clear and highlights the first important points!
Thank you. It is a fun learning :D. I created several buttons with cute messages from my kids and it makes me soooo happpyyyyy!
+Joy Tikoalu Good to hear you're having fun Joy! Your kids will be coding too, very soon ;-)
Finally an understandable video for true beginners... thank you very much!
You're very welcome Mr / Ms Jones. Keep coding!
Very clear. Thank you.
You're welcome - please check out the other videos on the channel
Hi, great work. You were born to teach. Question. I have been trying to modify a code to update a whole column with a single click. Example - An annual price rise percentage. I have found a code and with a small adjustment I can highlight a cell and individually adjust each item with a click but this is quite a laborious time consuming task. I don't know if this is even possible, but watching you and seeing how powerful excel is I think it could be done just not by me. Anyway fantastic video.
Mark - many thanks! Wouldn't it be best to but the price rise % in a cell that cells in the columns reference, and then simply adjust the figure in the cell?
Tiger Spreadsheet Solutions Hi thank you very much for answering. I will have a go and see what I can do. After watching your film on the buttons I had it in my head that it would be fun to to click a button to change a whole column, not thinking there is probably a simpler work a round. It's quite addictive trying out new things on excel. One again thank you.
Mark - yes it is addictive. I always tell people to treat it as 'play' if at all possible; this should maximise learning and the quality of the spreadsheet solution. Good luck!
Yeah !! I created my first button ..... Thanks Tiger :)
it is super helpful! Please go ahead with what you are doing. Super clear explanation
Thank you, Jane!
This is a begineer friendly. Thank you so much I learned alot
Welcome to the channel, Marvin!
This guy has to come from a long ancestral lineage of renowned English instructors, professors, and documentary narrators. I need you to explain life for me too.
But Jon, Excel *is* life.
@@TigerSpreadsheetSolutions Haha!!
Superb. To the point and crystal clear!
Glad you found it helpful!
Great tutor👍🏻, the presentation is clear and practical.
Thank you and welcome to the channel - do check out the other videos.
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 !!! 😁😁😁😁🤗🤗🤗
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 :-)
@@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... 👍👍👍👍👏
Plenty more videos to come...
Great lesson. Thank you.
Well explained and made simple.
Thank you, Z!
Thanks for making it simple
It's a pleasure and welcome to the channel
thank you....sir...not only learn but also I understand it so nicely
Thank you sir - please do check out the other videos on the channel
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.
Super. Very Good teaching, every body can understand
Thank you and welcome to the channel
Oh GOD, i created the first button in my life! Thank you so much! :)))))))))))))))
Good job! The first of many, hopefully :-)
Yes, it was the first for me too! =)
Thanks Tiger.
Tiger Spreadsheet Solutions where can i find vba codes ?
Excellent video!
Glad you liked it!
Top man well informed easy to understand..Thanks for sharing knowledge is Power.!!!!!
Could not agree more Mo - good luck!
My first step is successful ...
Thanks a lot :)
God bless you !
Thank you, and good luck with the rest of your coding journey!
Really appreciate. Thanks
Welcome to the channel!
wish most videos are like this one. thank so much
Many thanks and good luck with your coding
Amazing way of teaching. Simplifies everything
Very kind of you to say - the concepts are essentially simple, because a computer has to understand them. Good luck.
Good teacher. Explains it well.
Many thanks Luke and a big welcome to the channel
You´ve earned a Sub, kind sir. Outstanding work!
Thank you Thomas! Do check out the other videos on the channel ...
Loved this. Great
Thank you and welcome to the channel!
really like your video tutorial thank you for this
It's a pleasure - I hope you enjoy the rest of this series and good luck with your Excel learning
thanks so mach ihave no idea about VBA before these video go head
I'm glad the video helped - do check out the other videos on the channel
Your video is art: explained beautifully.
Thank you so much Melissa!
Thanks for the clear explanation !
You're welcome Martin - please check out the rest of our VBA tutorials. Good luck!
Well explained .. thank you
Many thanks Mark - do check out the other videos on the channel
From Connecticut , new England. Thanks for the video
Good to hear you are watching :-)
Very Simple & Easy you stated here Fantastic
Many thanks - hope it is a good starting point for you
It’s a nice tutorial, but I’m sure it will be better and more efficient if you remove your image which is taking a wide space. thanks
Amazing explanation... I wish all the people could explain like u
Great Tutorial, you helped me a lot - Thank you very much!
Thank you and welcome to the channel
Very helpful!
Thank you and welcome!
Amazing explanation.Thank you very much and appreciated
Thanks Muhammad and good luck with your VBA!
Thank you, it's so helpful
You're welcome Omar!
Nice way of teaching beginners. Great video. God bless
Thank you for watching!
This is the first time I use VBA and I just enjoy to create my first button :)
Happy New Year Year everyone Thanks for a great video. Very informative. Question: when you create a new module, will this work for all your workbooks/spreadsheets - or is it designated only towards the spreadsheet that was open at the time you designed the module?
Peps - happy new year to you too and thanks for the comment. No, code can work with any file. VBA can even open and close other files - it's super powerful but can cause problems if you are not sure which file or sheet is active. So, make sure you are explicit about the active file and active sheet. Again, this all comes with experience so don't let this consideration stop you practising! Good luck.
Very Good! You make it so simple easy to understand
Very simple teaching ... thank you
Thanks Ahmed and good luck with your coding.
Very good. Thank you...
Thank you Ali and welcome to the channel ...
Very well explained! Thank you!
It's a pleasure, please check out the other videos on the channel
Thank you so much starting a lesson from basic to build the basic beginning infrastructure.
Thank you and welcome to the channel - do check out the other videos ...
Great teacher! Thanks a lot!
You're welcome - please check out the other videos on the channel
Very good teaching
Thank you and welcome to the channel!
such a homie thank you
Cheers, Conor!
That was a great lesson for a biginner...
Thank you and welcome!
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
Nice tip, Alex!
Great video, nice clear speech, kindly Dean Australia
Thanks Dean and good luck with your coding down under!
Thank you so much for your useful explanation
Thank you Rith - please spread the word about the videos!
good job keep it up professional 4 stars
Thanks Gary and good luck with your coding.
Thanks
Good one. Small and precise.
Thank you and welcome to the channel
im going to show all my friends lol im a excel master now thanks
This man is awesome thanks mate
Cheers Kevin - good luck with you VBA!
wonderful development. keep up the good work
Thank you and welcome to the channel!
Well explained n the KEY was start with VERY rudimentary or basic step n beginners like myself can fellow indeed. Job VERY very well done Tiger n judging from below comments reflected what I say or what they say about quality explanations of your video. Thanks SO VERY MUCH indeed 4 sure!
Many thanks Markas. You're absolutely right, I try to break it down to the smallest possible step. Thanks for the comment and please spread the word about the videos.
Very well explained :)
Thanks for this video
Thank you and welcome to the community!
Hello Tiger!
Hi, Ronaldo!