Excel 2019 VBA Full Course Tutorial (7+ Hours) 

I have just started this course. I can say this is the best content on this subject I have ever encountered. That is very well explained and it motivates to continue.

I am not a native language english speaker and totally a beginner with VBA but I will try as hard as possible to can apply VBA in my work.Thank so much for this Great Video.

THANK YOU for being very detailed, Trish! I am a total beginner and have watched other great videos from other channels but none have shared full details into each part, as you have successfully done so. I am between jobs, and the new opportunities I am interested in require VBA expertise. Thank you for making this available at a free cost (unemployed), blessings to you always!

As someone who has never coded before, this was amazing and incredibly helpful, great tutorial!! 2:50:00 3:20:00

I belong to a non-tech background and needed some automation to do in order to reduce my daily effort in excel. This really helped a lot! Kudos to you

Can't believe that this amazing video is free. Thank you so Much.

Wow! This a great presentation. Comprehensive and easy to follow along. The presenter does an excellent job explaining concepts in an easy to understand manner.

the instructor has very defined teaching skills. Appreciations and thankings.

Outstanding job on the level of detail and patience for everyone learning. I learned alot throughout the 7 hours, this will definitely help me take my first steps in making my own dashboard. Thank you!

👍🏻 By far the best I’ve seen! I’ve learned more in less than 2 hours than I did with LinkedIn Learning. 👍🏻 Kudo’s to you Trish. I hope to learn more from you… now back to the course. 😎

This tutorial is honestly great, I haven't seen such an in-depth tutorial on Visual Basic in Excel and it really helped me, even while I was a bit known with Visual Basic for making Applications

You are amazing. This session is better than any other books or Tutorial I have seen!

Thank you SO much for this Lesson, I will watch this again. i need to learn again. God Bless you Dear ...

You are an outstanding instructor. That is so appreciated and so valuable. Thank you, Thank you.

Thank you so much for this precious content, It really gave me valuable intro and base at which I can start my VBA journey efficiently. Thanks

My goodness what a course. This is an amazing video of fantastic quality. 👏🏾

Dear Guys ! You put so much usefull stuff in here !! Awsome tutorial for someone who has some basic knowledge and wants to move up quickly . Please do more videos !

I'm starting into coding and this is a good video to start with. Thanks for putting this together! Is the PDF still available for rookies like me?

Thanks for the long video. This is very much effective in learning VBA. However, in creating Form and PivotTable part, it could have been better. Visualizing what the codes will produce while writing those in VBE was difficult. It would have been better if the outcome was shown at the beginning, rather than coding first and getting the output last. Thanks again for this nice informative video.

exactly what i have been looking for

I have watched the first 1.5hrs. Really informative ans easy to follow. Well done. Thank you.

This is an amazing instructor, with very clear, creative content. Thank you 💖

Hello Trish, I love this tutorial. I must say, its the best so far. And I really enjoy it. Pls, kindly drop the link to the power point slide for download. I couldn't find any link to that here in the description.

Hello, Thanks for this video! where can we dowlnoad the powerpoint please?

great course well structured and really useful. 10/10

Thank you very much, U'r super teacher because u made it easy and simple

Good stuff ! Had to run it at 1.25x speed, because I had programming experience and could skip some parts.

this very helpfull content on youtube especially i didn't see content like this because whenever i see content like this they are demanding charges thank you so much......

God bless you for this detailed and perfect illustration.

Thank you so much. This was really good, I have learnt a lot.

Phenomenal! Thanks so much for this tutorial

really helpfull; althought I feel it skipped explaining some really important concepts like what are classes, objects and methods in more detail and how to know which to use when

Love this tutorial! Thank you.

A BRILLIANT video! Thank you!

It is a good introduction for absolute beginners because you explain every step in detail. But working with Activate, ActiveCell, Select, Selection, Copy and Paste is very inefficient. You could get or set values directly to an object like VinNumber = shNewVehicles.Range("A2").Value or shNewVehicles.Range("A1").Value = "VIN". No need to activate or select the range, just get or set the value.

Very clear presentation and pleasant voice, excellent presenter 👍👍🌹🌹

thank u so much you giving something very valuble for free god bless you

This is a very detailed and helpful course. Thank you very much! I am not able to find the slides in the course description, could you share a link to downloading the slides?

Thank you so much for the detailed module. I have learned a lot from it.

Very informative.. I love to learn VBA from this video.

Yes, thank you very much for making a instruction video that makes me actually stay to the end.

I have a C++ background so this should be a breeze. Thanks for the 7-hour tutorial. Appreciate it.

Excellent Course

Thank you! I am about 3 hours in and I would really like the reference slide deck but I can't find it. When I access manuals there are several sub folders. Can you share where to access the presentation file?

excellent 👍

Thanks!

Very good course! But: 1) One Error: Dim a,b as String gives a the type Variant, not String! 2) The indentation technique is sometimes strange.

Since macros cannot be stored in the xlsx format, you can change Excel options to make the xlsm format (macro enabled format) the default. What is your opinion of this option?

Thanks!

Thanks a lot god bless you,👍

It is a great tutorial

AMAZING INSTRUCTOR ..

This is a wonderful course. Where do I find the slide deck to download?

Excellent presentation

I am currently working through the course but couldn't find the link to the PowerPoint slides used in the video. Is this something you are able to share?

Woah this is fresh! I just finished the 3 parts of VBA and this comes right on time. Thank you very much

very useful. plz share link to download PPT used in lecture

I can't find the PowerPoint slide for the course in the OneDrive Exercise File.

Great presentation. Much easier to understand . Much better than some paid courses.

Very useful, thanks. Is there a place that we can download the slides?

If you add a line to the top of the timestamps in the description that says "Introduction 0:00", then RU-vid will recognise your timestamps as video sections and display them in the video player.

I loved Trish's Class, just one problem. She keeps saying that her Powerpoint was included, but I can't find it anywhere. I did get the Powerpoint from Chelsea that she did, both from her class and Trish's class. Please help!

Hey! The link for the exercise files is not working, could you provide a new link, please? Edit: Made the link work, but I cant access the share point, I receive the error: "Selected user account does not exist in tenant 'Learn It , Inc' and cannot access the application '00000003-0000-0ff1-ce00-000000000000' in that tenant. The account needs to be added as an external user in the tenant first. Please use a different account."

Can you please explain if I add more vehilices in Received Vehicles.xlsx file, how to add more of these vehicles in the New Vehicles sheet in file Vehicles.xlsm? It copy only till the 11 row,what if I have more then eleven rows and not manualy to correct code.

In the end i get Runtime error 1004 Unable to get the PivotFields property of the PivotTable Class. What should i do to fix it?

Sometimes I get many files, I have to link with the scan copy of all these files, how can I do it, please tell me.

This is great. Thank you ❤

Google sheets has approximately 2 billion users, while excel has only 750 million. When do you intend to produce more videos for google sheets?

Fix Vehicles.xlsm closes or become unresponsive when trying to change G column formatting to Accounting/Currency

For the first exercise GetNewVehicles, I tried to copy and paste the values as instructed, but after saving the macro and running it, it opens the Received vehicles file and asks me if I want to save this copy of the file, then after I click ok, the macro continues to run but nothing is pasted. I use MacOS. Would like some help.

I've been writing VBA macros since Excel 2003 or earlier without problems. However when I added Office 2019 to a new laptop running Windows 11 and loaded my spreadsheets (using compatibility mode) the old macros don't work. Do you have a solution please ?

My code is slightly different because in order to follow along I have to minimize the Excel software and pause the video, but other than that, it's the same.

Please keep up this altruistic job so that we might get benefitted.

Do i need to select entire data in sheets to run the macro that is already there? .. what i mean is that if there are few more additional raws in the 2nd data sheet?

4:00:00 Why am i getting Error 13 on the Function GetClassification? and if i put else = Unknown it'll say unknown and not car

using this for my own learning 12:14

Super useful! 💙

get run-time error 9 when i execute the GetInventory macro. Please assist

Is excel 2016 able to do the same things?

I cannot find the slides used in the video.

crazy but YEAH ! super worth it

How to print specific page of multipage in userform?

At 6:12:13 I get and error Unable to get PivotFields property of the PivotTable class error (.PivotFields(PageName).Orientation = xlPageField ). Reviewed the whole lesson and could not figure out

5:14 Yep that's idea of encapsulation in C++ i.e., manipulating the member variables via the public methods and functions. In fact, modifying the member variables directly is dangerous. You never want to program software such that a user can directly access the variables. It could cause severe errors and the entire system to crash.

Hi, I can't see the Slide Deck., can you direct me, please? M

At 6:07:00 I get a compile error saying the GetDates procedure has not been defined. At what point is it created in the video?

Hi! Your videos are phenomenal! Thanks to you, I am already working on a portfolio to showcase my skills with reporting using macros for the pivot table fields! I have a quick question. I am trying to create a macro that toggles on and off a data field, but it only adds the field, its not removing it! Could you help me out¿ You are amazing! If Sheets("Test").PivotTables("Testeo").PivotFields("Comercial").Orientation = xlRowField Then ActiveSheet.PivotTables("Testeo").PivotFields("Suma de Comercial").Orientation = xlHidden Else Sheets("Test").PivotTables("Testeo").PivotFields("Comercial").Orientation = xlDataField End If

Thank you for the stuff, My code ended with this error, how to debug this Error msg "object doesn't support property or method" I click debug it highlighted this Set PvtTable = WorkSheets("Reports").PivotTable("SalesPivot") Using Excel 2016

My if structure function is not working. At the immediate window when i do the same thing it does not give me any result. ALso when i do run the msrp function at Inventroy sheet it gives just '0 instead of telling me less than bla bla. I'M checking the codes but everything is same. Can you help me?

Where is the PPT can anyone help me

slides not available in description

hola, no lo tienes en español?

I'm unable to follow the course because I use a Mackbook..... I'm sooo sad

can anyone give me the exercise files? I can't get access to it, showing an error!

Sales-fiscal year.xlsx file not opening

The link to exercise files does not work... 😅

Where is Chelsea? 😕

why youtuber starts with activating developer tab and wasting 2-3 minutes in it? If a person using VBA then he must know about developer tab.

1:06:34

Play in x1.5 speed. You're welcome