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
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.
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.
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 !
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......
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.
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
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?
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."
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!
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 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?
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.
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?
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.
If you add a line to the top of the timestamps in the description that says "Introduction 0:00", then RUclips will recognise your timestamps as video sections and display them in the video player.
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.
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 ?
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.
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
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?
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?
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
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
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
![Data Modeling for Power BI [Full Course] 📊](/img/1.gif)
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.
Wow, thanks!
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.
You can do it!
Can't believe that this amazing video is free. Thank you so Much.
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!
You are very welcome!
Thank you for being very detailed, Trish !
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
Glad it was helpful!
@@LearnitTraining Some timestamps would be incredibly helpful!
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
You are welcome!
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.
Glad you enjoyed it!
@@LearnitTraining WHERE do we find the slides?
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!
Glad it was helpful!
👍🏻 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. 😎
Glad it was helpful!
the instructor has very defined teaching skills. Appreciations and thankings.
You are welcome!
You are amazing. This session is better than any other books or Tutorial I have seen!
Wow, thank you!
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're very welcome!
Thank you SO much for this Lesson, I will watch this again. i need to learn again. God Bless you Dear ...
You are so welcome
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
You are most welcome
This is an amazing instructor, with very clear, creative content. Thank you 💖
You're so welcome!
My goodness what a course. This is an amazing video of fantastic quality. 👏🏾
Thank you so much!
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.
Thanks for the tips!
You are an outstanding instructor. That is so appreciated and so valuable. Thank you, Thank you.
Wow, thank you!
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.
Thank you for the valuable feedback!
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 !
Thank you for the kind words!
Good stuff ! Had to run it at 1.25x speed, because I had programming experience and could skip some parts.
Thank you for the kind words~!
I have watched the first 1.5hrs. Really informative ans easy to follow. Well done. Thank you.
Awesome, thank you!
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......
Thank you for the kind words! We believe everyone should have access to Office training!
Thank you very much, U'r super teacher because u made it easy and simple
You are very welcome!
thank u so much you giving something very valuble for free god bless you
You are so welcome!
exactly what i have been looking for
Great!
great course well structured and really useful. 10/10
Glad it was helpful!
Phenomenal! Thanks so much for this tutorial
You're very welcome!
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.
Unfortunately that files was lost. Sorry about that.
Love this tutorial! Thank you.
You are so welcome!
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
Glad it was helpful!
Thank you so much. This was really good, I have learnt a lot.
You're very welcome!
God bless you for this detailed and perfect illustration.
Thank you so much 😀
Hello, Thanks for this video! where can we dowlnoad the powerpoint please?
Very clear presentation and pleasant voice, excellent presenter 👍👍🌹🌹
Wow, thank you!
A BRILLIANT video! Thank you!
You are very welcome!
I have a C++ background so this should be a breeze. Thanks for the 7-hour tutorial. Appreciate it.
You're very welcome!
Very informative.. I love to learn VBA from this video.
Glad to hear that!
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?
Yes, thank you very much for making a instruction video that makes me actually stay to the end.
Thank you for watching!
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?
Yes please do share it they're really very helpful.
Thank you so much for the detailed module. I have learned a lot from it.
You are welcome!
Woah this is fresh! I just finished the 3 parts of VBA and this comes right on time. Thank you very much
You're very welcome!
Excellent Course
Glad you think so!
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.
Thanks for sharing!
Thanks a lot god bless you,👍
Most welcome 😊
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?
Please keep up this altruistic job so that we might get benefitted.
We definitely will Humayon Kabir!
Were is the slide deck that is talked about in the video? I don't see it anywhere above. Thanks.
AMAZING INSTRUCTOR ..
Thank you for the kind words saeed!
Thanks!
Thank you so much Python Programming! Your support helps us continue to make new videos each week!
excellent 👍
Thanks!
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?
Great presentation. Much easier to understand . Much better than some paid courses.
Thanks for sharing!
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."
Hello L G! We just tested the link and files. They are currently working.
@@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."
It is a great tutorial
Thanks!
I can't find the PowerPoint slide for the course in the OneDrive Exercise File.
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!
Here you go: bit.ly/3WH7ARY
@@LearnitTraining Thank you but your site was protected and I received a "Something went wrong" message
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.
This article from Microsoft may help - learn.microsoft.com/en-us/office/vba/api/overview/office-mac
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?
Excellent presentation
Thank you! Cheers!
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.
Hello Petar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
using this for my own learning
12:14
53:34
2:09:42
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.
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?
Hi Brooke! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining I did post my questions on Learnit 3 days ago with no response. What's the point if no one is going to respond?
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
get run-time error 9 when i execute the GetInventory macro. Please assist
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.
Google sheets has approximately 2 billion users, while excel has only 750 million. When do you intend to produce more videos for google sheets?
are you sure of this figure ? i believe excel has much more subscribers than GSheets
Hi Mteus! We are definitely looking into making more Google Sheets videos!
No one uses google sheets in corporate world.
This is great. Thank you ❤
You're welcome 😊
This is a wonderful course. Where do I find the slide deck to download?
Hello Raja! We normally do not provide the slide decks to our tutorials.
Fix Vehicles.xlsm closes or become unresponsive when trying to change G column formatting to Accounting/Currency
Noted!
If you add a line to the top of the timestamps in the description that says "Introduction 0:00", then RUclips will recognise your timestamps as video sections and display them in the video player.
Fixed! Thank you for catching that!
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.
I cannot find the slides used in the video.
very useful. plz share link to download PPT used in lecture
Thank you for watching!
@@LearnitTraining i am unable to find PPT link in the description. kindly help
Super useful! 💙
Glad it was helpful!
crazy but YEAH ! super worth it
Thanks for watching!
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?
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 ?
Hello ricban1950! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Play in x1.5 speed. You're welcome
👍👍👍👍👍
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.
Very useful, thanks. Is there a place that we can download the slides?
Hello Christos! We do not share our slides normally.
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
i have the same problem, have you found out yet?
Hi, I can't see the Slide Deck., can you direct me, please? M
Hello! We do not normally give out the slidedecks
@@LearnitTraining It says in the video that they are available with the exercise files. M
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?
Hello Mithun! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Where is the PPT can anyone help me
How to print specific page of multipage in userform?
Hello Masudhossain4880! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
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?
Hi Kendal! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
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
Hello Terrie! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Thanks!
Thank you so much Marc! Your support helps us to continue to make new training videos each week!
Is excel 2016 able to do the same things?
Much of the VBA coding portions and marcos can all be run in 2016 as well.
I'm unable to follow the course because I use a Mackbook..... I'm sooo sad
This article may help: learn.microsoft.com/en-us/office/vba/api/overview/office-mac
slides not available in description
1:06:34
can anyone give me the exercise files? I can't get access to it, showing an error!
We just tested the links and files and they are all currently working
hola, no lo tienes en español?
Pronto
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.
Hello channel-9 India. We always assume it is a person's first time using the program to be more inclusive.
Where is Chelsea? 😕
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
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
Sales-fiscal year.xlsx file not opening
Hello Jaiprakash! We tested the files and they are currently working