Very well done and very informative. Two notes/observations: 1) Accepting the default filename is great.... but if the user selects a different file, there are several hard-coded references about returning to the open file that would break. Might be good to address these other references. 2) Be great in a future update to demonstrate VBA used to clean data prior to running these repetitive tasks,( e.g. checking to see that all the source sheets are correctly formatted and that there aren't formulas or other cells, charts and other data that would impact the results. Thanks
If you're wondering near the end of the video why your MSRP column is not formatted for currency and the trainer's is, the trainer's MSRP column magically switches from not being formatted to currency to being formatted for currency between 2:14:17 and 2:14:19. I think you just need to manually format the MSRP column for currency and make the column wide enough to fit the dollar amounts. These videos have been great for learning.
Nah, she has some kind of sub procedure that adds width to the column that got missed in the tutorial..... I'm sure I saw something in the intellisense that sort of lead towards suggesting something about column widths.... but I can'r seem to locate it anymore.... or my eyeballs have gone crossed.🤣
I really like the way you first provide the description and then clearing it with examples. Thanks for that it help me to understand it more thoroughly. I have been studying and practicing VBA as a beginner level to intermediate level from youtube and never get a course with both theoritical and practical part. It will also help me to get confidence for the interview.
lot's of good stuff here. thanks for sharing. I was under the impression that any variable that was declared in one line separated by commas were declared as a variant type unless explicitly declared otherwise? IE Dim cat, dog, bird as strings. only bird would be string type where as cat and dog would be variants?
In the Sub (AddTotals) TotalFormula = "=sum(I2:" & LastCell.Address(False,False) & ")" can you explain why False, False is included in this statement rather than True, True. how would the end result affect the outcome. I am curious to understand why False versus True. Fantastic Tutorial perfectly detailed explanations.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
"Tell 'em what you're going to tell 'em, Tell 'em, Tell 'em what your told 'em"...love it!
Truth!
Very well done and very informative. Two notes/observations: 1) Accepting the default filename is great.... but if the user selects a different file, there are several hard-coded references about returning to the open file that would break. Might be good to address these other references. 2) Be great in a future update to demonstrate VBA used to clean data prior to running these repetitive tasks,( e.g. checking to see that all the source sheets are correctly formatted and that there aren't formulas or other cells, charts and other data that would impact the results. Thanks
Thank you for the great tips!
If you're wondering near the end of the video why your MSRP column is not formatted for currency and the trainer's is, the trainer's MSRP column magically switches from not being formatted to currency to being formatted for currency between 2:14:17 and 2:14:19. I think you just need to manually format the MSRP column for currency and make the column wide enough to fit the dollar amounts.
These videos have been great for learning.
Nah, she has some kind of sub procedure that adds width to the column that got missed in the tutorial..... I'm sure I saw something in the intellisense that sort of lead towards suggesting something about column widths.... but I can'r seem to locate it anymore.... or my eyeballs have gone crossed.🤣
This is one of the greatest vba lessons I run into so far. I am definitely stick with you for help with my projects.
We are glad it is so helpful! Thank you for watching!
I really like the way you first provide the description and then clearing it with examples. Thanks for that it help me to understand it more thoroughly. I have been studying and practicing VBA as a beginner level to intermediate level from youtube and never get a course with both theoritical and practical part. It will also help me to get confidence for the interview.
Thank you for the kind words! Good luck on your interview!
The Best EXCEL VBA tutorial! 👍👍
Thank you so much for watching Kebin! We hoped you learned alot!
Very useful video to start automating your daily work, thank you!
You are welcome!
Awesome 👌, The best vba tutorial by all standards.
Glad it was helpful!
lot's of good stuff here. thanks for sharing. I was under the impression that any variable that was declared in one line separated by commas were declared as a variant type unless explicitly declared otherwise? IE Dim cat, dog, bird as strings. only bird would be string type where as cat and dog would be variants?
Hello Matthew! This article may help answer your question: learn.microsoft.com/en-us/office/vba/language/concepts/getting-started/declaring-variables
Loved it very well explained :) Thank you
You are very welcome!
thank you very much!!
You are very welcome!
Wonderful tutorial but where do you discuss the "Get New Inventory" code? Am I missing something?
This video should help: ua-cam.com/video/JZ4pBe_MHQ8/v-deo.html
The linked exercise files are missing the modules that were given in the video. Am I downloading them incorrectly?
It seems vehicles file was modified.. no macros there..
We are looking into this!
thanks!@@LearnitTraining
Great videos, very effective. Also same question here, seems the vehicles file's missing some codes, thanks for looking into this.
good job , keep going and thanks
You are welcome! Thank you for the support!
Excelent Videos!! i learned a lot
Happy to hear that!
In the Sub (AddTotals) TotalFormula = "=sum(I2:" & LastCell.Address(False,False) & ")" can you explain why False, False is included in this statement rather than True, True. how would the end result affect the outcome. I am curious to understand why False versus True.
Fantastic Tutorial perfectly detailed explanations.
Hello Fredrick! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I could't find the models which you used during the video. Could you send it (Modifying a Sub Procedure to Include an Input Box)
Exercise Files: bit.ly/37mAIZM
on 1:29:21, how does VBA know to end the first "if" and not the second one??
Hi Nicolas! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
thank you for this ❤️
You're welcome 😊
Great..!
Thanks!
Hello, can I have the PowerPoint please?
Hello Mitchell! We do not normally give out the PowerPoints for our videos
@@LearnitTraining Do you think you might consider sharing them? They would be helpful for reference and for the learning process.
Excellent Video!!, Exercise files link is not working, Kindly guide how to download exercise files?
Hi Jitendra! We just tested the link and it is currently working
hey Guys i run through this error run-time error '1004' sorry we couldn't find the file passible move or delete
Hello Hussam! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
2:00:00
1:27:10