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!
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.
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
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 !
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.
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.
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......
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
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.
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! 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?
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?
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?
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."
@@LearnitTraining Hey! Made the link work another way, but I cant access the share point, I receive this 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.
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.
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?
Got the solution apparently for me the received vehicles sheet must be open for to get the macro running but it still doesn't pull the data just the header and formatting.
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! 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?
Chelsea Dohman?? The girl with a sweetheart voice. She did her version of Excel VBA tutorial and I went thru them all and understood everything. God bless learn it institution