Excel VBA Basics #1 - Getting started with Range object, running and debugging

Learn some of the basics in Visual Basic for Applications, VBA for Excel. In this video we learn How To:
Assign a value to a cell or cell range with VBA's Range object.
Get the developer tab in Excel's ribbon.

Fantastic Developer Tools:

[excelisfun]

When you started this channel I was working 12+ hours each day and did not have the time to watch your videos. I am now on a vacation for a few weeks and I am going to have some fun and watch all your videos! It is a great opportunity to learn so great tips about VBA! 1 video down and 36 more basic ones to go... and then on to your other playlists! Woo Hoo!

[gexcel]

I also agree when you say you owe your career to Mike, I also owe them, Mike and Bill, they are the best teachers of Excel of the world!

[rockguitarist]

This video is a blessing to those of us trying to better ourselves in our career on a budget. Big thanks!!!

[dipaklunawat]

Recently got promoted at my work.. Found out that VBA for Excel is used widely to carry out different activities in no time. Stumbled upon your channel.. thank you so much Daniel for these videos.. !!

[pavankumar-fgzb]

Learning VBA is never been so easy, I was searching for many tutorials online but they where hard to understand and this one stands out from all of them because its quite simple and easy to begin. thank you very much. Now I am a big fan of yours.

[MeshariAlkreadees]

I'm so happy that I found you channel. I'm new to VBA and going to learn how I program using VBA step by step by watching all your videos. Thanks a lot.

[ExcelVbaIsFun]

Excellent question. You can create a sub in either, but in general, modules are for general subs and functions. Sheets are where you store subs related to items in that particular sheet or worksheet events related to that sheet (aka when sheet is activated or a cell is changed on THAT sheet or an Activex control like a button is clicked). Workbook is for storing events that are workbook wide (aka ANY sheet is activated or a cell is changed on ANY of the sheets.) Thx! Dan

[rodrigocustodio]

It is so cool you acknowledge Mike, such an act of humility and gratitude! thank you for your videos, Mike's videos from Excelisfun also transformed my life! Now I will follow your series as well.

[rajassy]

Thank you for the video, Jotting down what i learnt in the video - may be helpful for others as well Add 'Developer' command to Ribbon
Invoke a VBA editor
Insert Module
Include a Range in the VBA editor (Basic)
Passing text /numeric value to Range
Run macro in VBA page
Debug line by line
Show the pre and post values for a line during debug
Run macro outside VBA editor (from Excel Sheet)

[SantoshSharma]

Your English is very easy to understand than the person you have told in this video. thanks for uploading video . i was searching for some one with clean voice and accent

[rodrigocustodio]

Man I would not watch your video because I am a fan of mike Girven, I thought this was an extension of his channel, but after you acknowledge Mike I will also watch your videos. It is nice you talk about Mike!

[ExcelVbaIsFun]

Well, on behalf of the excel community, thanks for ALL your publications and projects! We're lucky to have you and sincerely appreciate all your hard work! Dan

[christiannepogie]

I have to say that I like the way you demonstrate using basic macro on a good phase. Others explain it in a very technical and fast phase. I am definitely watching all your videos. Makes me want to go home immediately and play with my Excel. Excel-ent Job!

[sabrinamimouni]

2020 and Mike is still the Excel master 👍👍👍👍

[JoeKeever]

I just finished watching all 39 videos in the Basic playlist! You really do a great job in taking a somewhat frustrating language to learn and making it enjoyable. I look forward to watching the others.... Thank you!

[danielmiller]

Excel VBA is Fun! And also extremely useful and powerful! I learned VBA from people like you and John Walkenbach's Excel 2010 Power Programming with VBA. Keep up the good work!

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

You're very welcome Shana! Thanks for your kind comments!

[hirenthanki]

Great to see a reference to Mike in the intro of your video.

[pradeeprvim]

wow you are awesome, very simplified way of explaining VBA, many thanks Daniel