Watched both the 2019 and 2021 versions and learned a lot... very comprehensive. There were a few recording and consistency issues (edits that repeated content, undefined terms, inconsistent variable names), but my real issue was that I think the pace changed considerably around Lesson 6. A lot of the code explanations disappeared (more like overviews of the imported files) and assumptions were made about the learner's grasp of the concepts presented earlier. Strategic choice to save time, but I found the last few lessons more difficult to follow because of this. Still, a tremendous effort and an amazing bargain (FREE!). Thanks.
Could you tell me where that line of code goes? Thanks for your comment, I was wondering for a while where things went wrong and thanks LearnIt for the great videos.
Hi Trish, I'm halfway through the course and I'm loving it so far. Thank you so much for your clear explanations! I have a suggestion that might help improve the course. Sometimes, it would be beneficial to include brief quizzes or questions on the material we've just covered. Additionally, providing a moment to think about the answers before revealing them would be very helpful. These techniques can enhance learning and retention through active engagement and reflection. Thanks again for the quality of your course. I hope this feedback is helpful. Best regards !
I tried to type as you "GetNewInventory" at moment 1:30:33 and when I complied the file I have an error: Ambiguous name detected: GetNewInventory. Can you advise me what should I do? Thank you!
Excellent! I loved the whole presentation. I have one question about declaring variables in a single line. My experience as been that if separate each variable by a comma and then add "as integer" at the end of the line, Only the last variable is declared properly. The others are declared as variant. What am I doing wrong?
I can't believe I have completed this complete 7 hours lecture in just 5 days. So much organized way of teaching which made me interested in learning. One thing I want to ask that how we can learn and know the syntax of codes? any easy methods of it? If yes please do tell me. Thank you
again, Ive followed the video, each section, 3 time, Sub GetNewInventory 1:23:40 and read and reread the code, compiled with no errors and then ran the macor and recieved the following Run Time Error "9": Subscript out of Range??? thank you
Great course! At 16:32, you can undo the last step by pressing ctrl C, I tried to do the same on my lenovo laptop, but it didn't work out, instead, it just copied a cell. What can I do?
The Toolbox Keeps disappearing and I have to shut down the entire file and restart to get it back making the form section of this impossible to complete. What am I doing wrong? It's not on another screen, I minimized everything else looking for it, and just touching anything else seems to make it disappear even though it still says it's active in the dropdown menu. Click that on and off does nothing. I'm frustrated to tears over this.
@@LearnitTraining I am using Windows 10 Home, and it is not compatible with "Install Remote Server Administration Tools (RSAT)", which is Step 1 in the article above. Any help on how to proceed would be appreciated.
I'm new to VBA and would like to take the time to to watch and learn but I have Excel 365. Would this still be the proper course despite having a different version of Excel?
For some reason my code does not return the correct answer . Function MSRPStatus(MSRP) If MSRP < 20000 Then MSRPStatus = "Less than 20K" ElseIf MRSP < 30000 Then MSRPStatus = "Less than 30K" Else: MSRPStatus = "Greater than or equal to 30000" End If
End Function ?MSRPStatus(10000) Less than 20K Print MSRPStatus(20000) Less than 30K ?MSRPStatus(50000) Less than 30K Can not get this to work. I am using Office Pro Plus 2021. Any ideas would be helpful
Watched both the 2019 and 2021 versions and learned a lot... very comprehensive. There were a few recording and consistency issues (edits that repeated content, undefined terms, inconsistent variable names), but my real issue was that I think the pace changed considerably around Lesson 6. A lot of the code explanations disappeared (more like overviews of the imported files) and assumptions were made about the learner's grasp of the concepts presented earlier. Strategic choice to save time, but I found the last few lessons more difficult to follow because of this. Still, a tremendous effort and an amazing bargain (FREE!). Thanks.
Thank you for the tremendous feedback! We will strive to do better!
Excellent course, well-structured and well presented. Awesome job Trish!
Thank you for the kind words!
The voice is very relaxing, I can easily follow the exercises.
Thanks! We hope you learned a lot!
3:20:50. I believe you've omitted this line YearMarker = Mid (VinNum,11,1)
which made me confused for a while. Anyway, great lessons!! Thank you
Thanks for the tip!
Could you tell me where that line of code goes? Thanks for your comment, I was wondering for a while where things went wrong and thanks LearnIt for the great videos.
Hi I loved your video. I am also a VBA programmer and just started a channel teaching how to work with opengl in Excel through VBA
Best of luck!
Hi Trish,
I'm halfway through the course and I'm loving it so far. Thank you so much for your clear explanations! I have a suggestion that might help improve the course. Sometimes, it would be beneficial to include brief quizzes or questions on the material we've just covered. Additionally, providing a moment to think about the answers before revealing them would be very helpful. These techniques can enhance learning and retention through active engagement and reflection.
Thanks again for the quality of your course. I hope this feedback is helpful.
Best regards !
Thank you for watching and wonderful feedback!
2 to 5 minute{ > .; < {.}
space. troop. observation. space.
underlying _
dynamics fix, term
width, Databricks, secret scope, virocity calculations.
will of the key, branch & roots activation card.
Azure storage account.
Application (NOEL) I.D. Microsoft Entra I.P.
Component of overfitting////information through all : clinical trials.
Documentation, the cell null, gross capital. Synapsis. new/Spark 'run' this cell |\. \. \ imprint needed, initial command begin.
Great initiative trish.explain to the point and concise.
Thank you for watching!
1:47:42 starts VBA Intermediate
Great timestamp!
very well expained and structured course . Thanks for your efforts
Most welcome!
I tried to type as you "GetNewInventory" at moment 1:30:33 and when I complied the file I have an error: Ambiguous name detected: GetNewInventory. Can you advise me what should I do? Thank you!
Excellent course. Thank you very much for making it available on RUclips. Where can I get the class slides?
Excellent! I loved the whole presentation. I have one question about declaring variables in a single line. My experience as been that if separate each variable by a comma and then add "as integer" at the end of the line, Only the last variable is declared properly. The others are declared as variant. What am I doing wrong?
I really enjoyed the course. How do I access the slide deck?
Thanks for Hard Work ..Appreciate that God Bless You .
You are welcome!
I can't believe I have completed this complete 7 hours lecture in just 5 days. So much organized way of teaching which made me interested in learning.
One thing I want to ask that how we can learn and know the syntax of codes? any easy methods of it? If yes please do tell me. Thank you
This article may help: www.educative.io/blog/learn-how-to-code-beginners-guide
I really appreciate your effort in producing this stunning video ❤
Hi! Thank so much for this course. I am wondering where i am able to find the presentation slides
excellent!! i am in here, let's start...
Hope you learned everything you needed!
again, Ive followed the video, each section, 3 time, Sub GetNewInventory 1:23:40 and read and reread the code, compiled with no errors and then ran the macor and recieved the following Run Time Error "9": Subscript out of Range??? thank you
Hello Alan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Thanks!
Thank you so much MokhlisAbderrahim! Your support helps to continue making new videos each week!
Great course! At 16:32, you can undo the last step by pressing ctrl C, I tried to do the same on my lenovo laptop, but it didn't work out, instead, it just copied a cell. What can I do?
Hello Donald! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
The proper shortcut you are looking for is CTRL Z
Hi.. what is the different using excel formula in excel and using sub procedure If.. Then
Excellent!!!!!
Many thanks!
Excellent. thanks for sharing
Youare welcome!
Thank you so much 💐
You're most welcome!
The Toolbox Keeps disappearing and I have to shut down the entire file and restart to get it back making the form section of this impossible to complete. What am I doing wrong? It's not on another screen, I minimized everything else looking for it, and just touching anything else seems to make it disappear even though it still says it's active in the dropdown menu. Click that on and off does nothing. I'm frustrated to tears over this.
"ctrl o" does not open active directory. Could you tell me how to do that?
This article may help -techcult.com/how-to-enable-active-directory-in-windows-10/
@@LearnitTraining I am using Windows 10 Home, and it is not compatible with "Install Remote Server Administration Tools (RSAT)", which is Step 1 in the article above. Any help on how to proceed would be appreciated.
Please provide exercise files it would be greatful for beginners
were can i find the powerpoint used in the video, i cannot find it in the exercise files
Good question, it wasn't in mine either.
Thank you! :)
You are welcome!
I'm new to VBA and would like to take the time to to watch and learn but I have Excel 365. Would this still be the proper course despite having a different version of Excel?
There will be minor differences but 90% of the content will still be relevant
00:43:36
👍👍👍
how do I access the files you are using in the video
learnitanytime.com/p/exercise-files-excel-2021-vba-full-course-tutorial
Please make a video on powerpoint also
The full course one is coming soon!
How can I add an empty paragraph to word? Selection.InsertParagraph gives an error
Hello Jure! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I think you need to update your videos?? i.e. topics?? where is that??
Great Course. Am I the only one who cant find the slide deck?
For some reason my code does not return the correct answer . Function MSRPStatus(MSRP)
If MSRP < 20000 Then
MSRPStatus = "Less than 20K"
ElseIf MRSP < 30000 Then
MSRPStatus = "Less than 30K"
Else: MSRPStatus = "Greater than or equal to 30000"
End If
End Function
?MSRPStatus(10000)
Less than 20K
Print MSRPStatus(20000)
Less than 30K
?MSRPStatus(50000)
Less than 30K
Can not get this to work. I am using Office Pro Plus 2021. Any ideas would be helpful
There is a typo in your code.
"ElseIf MRSP < 30000 Then"
It should be:
"ElseIf MSRP < 30000 Then"
FYI, your website is not the most user friendly, Im sorry
Why
🎉🎉
🎉🎉
00:43:36
👍👍