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!
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
👍🏻 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 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......
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.
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.
If you add a line to the top of the timestamps in the description that says "Introduction 0:00", then UA-cam will recognise your timestamps as video sections and display them in the video player.
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?
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
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 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?
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.
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.
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?
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.
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.
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 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 ?
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
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!
Can't believe that this amazing video is free. Thank you so Much.
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!
Thanks!
Thank you so much Python Programming! Your support helps us continue to make new videos each week!
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!
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 !
May God bless you for this detailed and perfect illustration. Thank you so much.
You are very 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?
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
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!
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
the instructor has very defined teaching skills. Appreciations and thankings.
You are welcome!
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!
You are amazing. This session is better than any other books or Tutorial I have seen!
Wow, thank you!
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!
My goodness what a course. This is an amazing video of fantastic quality. 👏🏾
Thank you so much!
👍🏻 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!
I have watched the first 1.5hrs. Really informative ans easy to follow. Well done. Thank you.
Awesome, thank you!
exactly what i have been looking for
Great!
You are an outstanding instructor. That is so appreciated and so valuable. Thank you, Thank you.
Wow, thank you!
great course well structured and really useful. 10/10
Glad it was helpful!
Phenomenal! Thanks so much for this tutorial
You're very welcome!
Love this tutorial! Thank you.
You are so welcome!
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!
Thank you so much. This was really good, I have learnt a lot.
You're very welcome!
Great presentation. Much easier to understand . Much better than some paid courses.
Thanks for sharing!
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!
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!
My VBA code has often removed the feature validation list within the VBA code. What should I do to fix it?
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.
Thanks!
Thank you so much Marc! Your support helps us to continue to make new training videos each week!
This is an amazing instructor, with very clear, creative content. Thank you 💖
You're so welcome!
Hello, Thanks for this video! where can we dowlnoad the powerpoint please?
A BRILLIANT video! Thank you!
You are very welcome!
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~!
God bless you for this detailed and perfect illustration.
Thank you so much 😀
Very informative.. I love to learn VBA from this video.
Glad to hear that!
Very clear presentation and pleasant voice, excellent presenter 👍👍🌹🌹
Wow, thank you!
Excellent Course
Glad you think so!
excellent 👍
Thanks!
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
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!
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?
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!
It is a great tutorial
Thanks!
Thank you so much for the detailed module. I have learned a lot from it.
You are welcome!
I have a C++ background so this should be a breeze. Thanks for the 7-hour tutorial. Appreciate it.
You're very welcome!
Yes, thank you very much for making a instruction video that makes me actually stay to the end.
Thank you for watching!
Thanks a lot god bless you,👍
Most welcome 😊
If you add a line to the top of the timestamps in the description that says "Introduction 0:00", then UA-cam will recognise your timestamps as video sections and display them in the video player.
Fixed! Thank you for catching that!
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.
Excellent presentation
Thank you! Cheers!
AMAZING INSTRUCTOR ..
Thank you for the kind words saeed!
Were is the slide deck that is talked about in the video? I don't see it anywhere above. Thanks.
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?
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?
Super useful! 💙
Glad it was helpful!
This is great. Thank you ❤
You're welcome 😊
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?
I can't find the PowerPoint slide for the course in the OneDrive Exercise File.
using this for my own learning
12:14
53:34
2:09:42
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!
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."
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?
crazy but YEAH ! super worth it
Thanks for watching!
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.
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.
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?
Fix Vehicles.xlsm closes or become unresponsive when trying to change G column formatting to Accounting/Currency
Noted!
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
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!
Very useful, thanks. Is there a place that we can download the slides?
Hello Christos! We do not share our slides normally.
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?
I cannot find the slides used in the video.
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/
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
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.
Please keep up this altruistic job so that we might get benefitted.
We definitely will Humayon Kabir!
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.
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
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
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
Where is the PPT can anyone help me
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
slides not available in description
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.
hola, no lo tienes en español?
Pronto
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
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.
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
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
1:06:34
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
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
The link to exercise files does not work... 😅
Hello GYUTAE! We just tested the link and files and they are all currently working
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
Sales-fiscal year.xlsx file not opening
Hello Jaiprakash! We tested the files and they are currently working