Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros
ฝัง
- เผยแพร่เมื่อ 15 ก.ย. 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
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
@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!
Amazing explanation... I wish all the teachers could explain like u ...Thank u very much.
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 ...
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
Finally a really well explained tutorial for beginners. Thanks
Welcome to the channel - do check out our other videos
I completely fell in love with you. Seriously! Best programming teacher ever. Thank you from Argentina.
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
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 :-)
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?
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!
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!
Very clear. Thank you.
You're welcome - please check out the other videos on the channel
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!
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.
Amazing lesson, subscribing here needs no thinking. Thank you very much.
A big welcome to the channel, Paul!
Finally an understandable video for true beginners... thank you very much!
You're very welcome Mr / Ms Jones. Keep coding!
Sending wishes from Sri Lanka to continue with this great teaching
Thank you for the lovely comment!
Yeah !! I created my first button ..... Thanks Tiger :)
Superb. To the point and crystal clear!
Glad you found it helpful!
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 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 :-)
Thanks for a clear and easy intro to VBA!
It's a pleasure and welcome to the channel!
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 ;-)
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 :-)
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.
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
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.
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.
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!
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 👍
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!
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!!
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! 🔥
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!
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!
Fantastic. 'Great teacher: very clear and highlights the first important points!
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 :-)
Great tutor👍🏻, the presentation is clear and practical.
Thank you and welcome to the channel - do check out the other videos.
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 ?
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
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
My first step is successful ...
Thanks a lot :)
God bless you !
Thank you, and good luck with the rest of your coding journey!
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...
From Connecticut , new England. Thanks for the video
Good to hear you are watching :-)
Top man well informed easy to understand..Thanks for sharing knowledge is Power.!!!!!
Could not agree more Mo - good luck!
Amazing explanation... I wish all the people could explain like u
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.
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.
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 ...
Good teacher. Explains it well.
Many thanks Luke and a big welcome to the channel
Nice way of teaching beginners. Great video. God bless
Thank you for watching!
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!
wish most videos are like this one. thank so much
Many thanks and good luck with your coding
fabulous, clear and simple
Thank you and welcome to the channel!
Great lesson. Thank you.
Your video is art: explained beautifully.
Thank you so much Melissa!
Very Simple & Easy you stated here Fantastic
Many thanks - hope it is a good starting point for you
Very simple teaching ... thank you
Thanks Ahmed and good luck with your coding.
You´ve earned a Sub, kind sir. Outstanding work!
Thank you Thomas! Do check out the other videos on the channel ...
Great video, nice clear speech, kindly Dean Australia
Thanks Dean and good luck with your coding down under!
Super. Very Good teaching, every body can understand
Thank you and welcome to the channel
im going to show all my friends lol im a excel master now thanks
Well explained and made simple.
Thank you, Z!
Amazing explanation.Thank you very much and appreciated
Thanks Muhammad and good luck with your VBA!
Thanks for the clear explanation !
You're welcome Martin - please check out the rest of our VBA tutorials. Good luck!
Very clear Tutorial. Excellent coaching. Thank you so much
Great Tutorial, you helped me a lot - Thank you very much!
Thank you and welcome to the channel
This is the first time I use VBA and I just enjoy to create my first button :)
good job keep it up professional 4 stars
Thanks Gary and good luck with your coding.
Thank you, it's so helpful
You're welcome Omar!
That was a great lesson for a biginner...
Thank you and welcome!
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.
Thanks for making it simple
It's a pleasure and welcome to the channel
This is great. easy to understand. very articulate
Very Good! You make it so simple easy to understand
Thank you for the explanation, i have watch the tutorials for beginners. I hope i can be an expert. :)
Thank you so much for your useful explanation
Thank you Rith - please spread the word about the videos!
Very well explained! Thank you!
It's a pleasure, please check out the other videos on the channel
Excellent video!
Glad you liked it!
great tutorial.very clear and helpful! thanks
Good tutorial
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.
Thanks from Pakistan
thanks for the great video! the instructor screen could probably be a bit smaller next time ;)
Thank you and feedback noted
Great teacher! Thanks a lot!
You're welcome - please check out the other videos on the channel
Thank you so much TIGER SPREADSHEET SOLUTIONS for the practical way of teaching!! really superb :-)
Thanks Deepak - good luck with your coding :-)
Very good teaching
Thank you and welcome to the channel!
Well explained .. thank you
Many thanks Mark - do check out the other videos on the channel
i like your video... thanks for teaching step by step 😊
Thanks Mahesh and please do check out the other videos on the channel
Tiger Spreadsheet Solutions Sure Sir i have subscribed your channel i will watch all videos.
Sir would you please tell me how get Job in Excel
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!
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
Thank you so much I enjoyed and I have an idea about it now....it help me a lot speacialy in my work I need create some like this I know not this say hello but I got a good idea ty master .
Gordon freeman Thank you Gordon, and good luck with your spreadsheets!
Really appreciate. Thanks
Welcome to the channel!
Good one. Small and precise.
Thank you and welcome to the channel
amazing and simple technic, most important best technic to teach someone......great teacher...👌👌👌👌
Many thanks - the simple techniques are the most powerful and in my view, the most important
Thanks Chris. Awesome video. Very well explained.