Excel VBA Beginner Tutorial




About this tutorial:

Video duration: 02:10:31
Excel VBA Beginner Tutorial

Excercise Files:

Manuals:
Username: manuals
Password: password

Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

48 thoughts on “Excel VBA Beginner Tutorial

    Kossivi AGLEE

    (June 29, 2020 - 6:36 pm)

    My VBA window doesn't look as nicely as yours with each view panel scrolled in each other. For me the "VBA Project" panel and "Code" panel are still having their "Minimize", "Maximize", and "Close" buttons.

    William Wilbanks

    (June 29, 2020 - 6:36 pm)

    I am getting syntax error during the first macro. Following video to the T and still getting error. Using windows 10. Any suggestions?

    digital eye

    (June 29, 2020 - 6:36 pm)

    just great!!!!

    liam hickson

    (June 29, 2020 - 6:36 pm)

    Has anyone cracked this yet? I'm trying to create a macro that shows me the last time a tab was edited (actually edited not just opened) and have it show up on each tab so I can track when people are completing work. But I cant get it to work :/ not even sure its possible at this point….

    Sumsaam Ali

    (June 29, 2020 - 6:36 pm)

    Hi, its a good course easy to learn. tell me please which comes after this VBA Advanced? or VBA Expert course? thank you

    Leomr 60

    (June 29, 2020 - 6:36 pm)

    Her voice makes me feel like she is the Bob Ross of Excel

    Erasmus

    (June 29, 2020 - 6:36 pm)

    I used to skip all the tutorial with 30+ minutes long. But not this one.

    BARUN

    (June 29, 2020 - 6:36 pm)

    this is a really great video.

    Common Sense Vlog

    (June 29, 2020 - 6:36 pm)

    Thanks for this video! i have learned a lot and it's so simple to understand because the way you explained is not complicated and you have so sexy voice…

    Ahmed Amr

    (June 29, 2020 - 6:36 pm)

    This tutorial is by far one of the best tutorials ever, the methodology is very good, even if used with any other topic especially programming.
    Instead of spending 10+ lessons learning how to print silly message on the screen and doing loops and conditional formatting, you start doing some useful examples and get your hands on with real, yet simple scenarios.
    I would really recommend your channel for anyone who want to learn anything, not just Excel.
    Please it going 🙂

    811414182梦见

    (June 29, 2020 - 6:36 pm)

    On the last exercise in the video, I recommend creating a new procedure that will call in all the macros that you just made, so that you can format each sheet with one macro click only 🙂

    Amol Wankhede

    (June 29, 2020 - 6:36 pm)

    Tutorial has been conducted in Excellent manner. Perfect for Beginner.

    Shyamal Ganguly

    (June 29, 2020 - 6:36 pm)

    True direction for learning XL in an unique fun way kind of freezbee playing and you never have the thought of someone is actually making you knowledgeable. I love the coaching, be there I'm getting ready to be an expert in VBA. God bless everyone including you.

    Farhan Shaker

    (June 29, 2020 - 6:36 pm)

    I saved some Macros in "All work books or Personal work book" how can I change or delete this one. please help me out. waiting for your response

    Sidharth Maheshwari

    (June 29, 2020 - 6:36 pm)

    Best

    Ravi Kiran

    (June 29, 2020 - 6:36 pm)

    your voice is very pleasant to hear

    Raymond Tang

    (June 29, 2020 - 6:36 pm)

    very well explaination and demostration.
    I have subscribed this channel.

    Wu Paul

    (June 29, 2020 - 6:36 pm)

    1:56:36 should be Sheets(1).Select
    not Sheet(1).Select

    thanhvan28007 Zousbroveagyia Blogs

    (June 29, 2020 - 6:36 pm)

    boxing

    Noah Ligpitan

    (June 29, 2020 - 6:36 pm)

    Really Awesome Tutorial

    Mr pink

    (June 29, 2020 - 6:36 pm)

    That was so nice. I learned a lot. Thanks!!!

    sky walker

    (June 29, 2020 - 6:36 pm)

    I think I fell in love with you!! That unearthly voice and how you speak!!!! <3

    asim shah

    (June 29, 2020 - 6:36 pm)

    Best Teacher Every Appreciate it

    Gokulnath R

    (June 29, 2020 - 6:36 pm)

    Good content. Way of presentation is top class. Credits to chelsea. Really helpful. Please Learnit, keep sharing great contents like this.

    yogish s

    (June 29, 2020 - 6:36 pm)

    Its Really good for the beginners……Thank a lot!!!!

    Sourav Kar

    (June 29, 2020 - 6:36 pm)

    It's better than the beginner level Excel VBA courses in paid platforms like Udemy. Thank you so much for helping so many people.

    Lorrian Landicho

    (June 29, 2020 - 6:36 pm)

    This is very helpful, thank you very much. I have a quick question –
    On Multi-Step Macro recording
    :
    You recorded the macro on phone number ( and birthday) on just a single cell. You then selected the rest of the column to run it and it worked. Whereas in the last 4 of SS#, you recorded the macro for the entire column. Why? I tried recording a macro on a single cell (just like you did on the phone number) on SS# and tried to run on the entire column but it was only applied to the top cell. Am I missing something?

    Anthony Grooms

    (June 29, 2020 - 6:36 pm)

    If I click the clear filter button while the table is already filtered, I get a "Run Time Error 1004 Show All Data Method Of Work Sheet Class Failed"

    Anthony Grooms

    (June 29, 2020 - 6:36 pm)

    My buttons move all over the place when I click them.

    Anthony Grooms

    (June 29, 2020 - 6:36 pm)

    37:15 How did you do that there?

    Έξυπνη Σιτα

    (June 29, 2020 - 6:36 pm)

    In the 1.27.22 part of the video, the file gives an error in the percentage Selection.Style of the FmtTxt() sub. Is anybody else getting that or?

    Ali Razzaq

    (June 29, 2020 - 6:36 pm)

    Thanks a lot. I just completed the first video and practiced all the assignments. I heard about Macros in my college days but due to non-programming background always avoided them. Now after taking this course, with the pleasant voice of the instructor, I am feeling confident and want to master Macros. Gonna share this with all my friends. Love from Pakistan.

    AlanF

    (June 29, 2020 - 6:36 pm)

    Best tutorial I have seen in years
    The voice work and arrow and mini reviews for each step are exceptional.

    I will use these techniques when I return to teaching and will recvomend your channel to my students
    Thank you

    JONNABELLE YULO

    (June 29, 2020 - 6:36 pm)

    thanks for this video. i have learned a lot. 🙂

    Saurabh Kulkarni

    (June 29, 2020 - 6:36 pm)

    Good content, beautifully explained & soothing voice, thanks a ton!

    vincent cheruiyot

    (June 29, 2020 - 6:36 pm)

    Where did you download simple macro file…please i am stuck

    Denizz mil

    (June 29, 2020 - 6:36 pm)

    i love it!!

    Pablo Cano

    (June 29, 2020 - 6:36 pm)

    This sounds like Pamela form Khan Academy! Such a good teacher. Great video too.

    Damilola Kuteyi

    (June 29, 2020 - 6:36 pm)

    This is awesome!

    Asim Hussain

    (June 29, 2020 - 6:36 pm)

    Great course. I'm concurrently using a paid course on Udemy. It's dense and thorough, but the pedagogy is waaaay too fast. And the narration isn't mellifluous like this is. This made clear a lot of shit I learned in the other course but at a reasonable pace — clearer and more digestible.

    namulema caroline

    (June 29, 2020 - 6:36 pm)

    How to I download the simple macros files

    Charlene Shaulis

    (June 29, 2020 - 6:36 pm)

    Excellent!

    sathish b

    (June 29, 2020 - 6:36 pm)

    Amazing video! Must watch for anyone who wants to learn it the right way! Crisp and clear! Thank u so much!

    Hồ Võ Minh Nhân

    (June 29, 2020 - 6:36 pm)

    All this knowledge for free. Thank you!

    I try to not skip as many ads as possible when watching these tutorials, I hope it's enough for all the hard work you guys have put into this.

    Mars2Venus

    (June 29, 2020 - 6:36 pm)

    I am going to tell my friends about this course. Very well placed & explained.

    David Hogan

    (June 29, 2020 - 6:36 pm)

    Sounds like Kristen Bell!

    roberto cardeñosa

    (June 29, 2020 - 6:36 pm)

    As a feedback I state that this one is an awesome course on VBA. I'm thankful that the lady speaks very clearly too, it helps a lot to keep track on the arguments without having to repeat. Bravo!

    64mustangfan

    (June 29, 2020 - 6:36 pm)

    Fabulous! You became my lockdown tutor, with a clear, smooth and pleasant voice, well paced and delivered. In particular, you explain the smallest things, – you must have dropped 100 Excel tips in passing, and even though I use Excel frequently I'd unlearned some useful basics I don't always use, like a double click to auto fill. This is a standard of how great tutorials should be done, thank you 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *