Excel 2021 VBA Full Course Tutorial (6+ Hours)

[@catboy721]

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.

[@LearnitTraining]

Thank you for the tremendous feedback! We will strive to do better!

[@DAGenao]

Excellent course, well-structured and well presented. Awesome job Trish!

[@LearnitTraining]

Thank you for the kind words!

[@MieszkoKrychniak]

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!

[@JamesWray-r9b]

I really enjoyed the course. How do I access the slide deck?

[@MyBWR]

Great Course. Am I the only one who cant find the slide deck?

[@anhlenguyen404]

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

[@LearnitTraining]

Thanks for the tip!

[@MochaRose990]

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.

[@animust482]

Hi! Thank so much for this course. I am wondering where i am able to find the presentation slides

[@nbforme]

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?

[@letmedie4you]

very well expained and structured course . Thanks for your efforts

[@LearnitTraining]

Most welcome!

[@claudineyribeiro518]

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

[@LearnitTraining]

Best of luck!

[@sanj6576]

1:47:42 starts VBA Intermediate

[@LearnitTraining]

Great timestamp!

[@farzadshirani7324]

Excellent course. Thank you very much for making it available on KZbin. Where can I get the class slides?

[@louieandrofuertes9146]

The voice is very relaxing, I can easily follow the exercises.

[@LearnitTraining]

Thanks! We hope you learned a lot!

[@rexomath]

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

[@LearnitTraining]

This article may help: www.educative.io/blog/learn-how-to-code-beginners-guide

[@alexflame1713]

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 !

[@LearnitTraining]

Thank you for watching and wonderful feedback!

[@junaidtanoli6000]

Great initiative trish.explain to the point and concise.

[@LearnitTraining]

Thank you for watching!

[@LaurenYork-Toenniges]

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.

[@kebincui]

Excellent. thanks for sharing

[@LearnitTraining]

Youare welcome!

[@j.n.8855]

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?

[@LearnitTraining]

There will be minor differences but 90% of the content will still be relevant

[@alan9171]

FYI, your website is not the most user friendly, Im sorry

[@fahadalqarni2068]

Why

[@donaldtze9878]

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?

[@LearnitTraining]

Hello Donald! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

[@YouTubeGaveMyHandleAway]

The proper shortcut you are looking for is CTRL Z

[@GiangPham-fw9kf]

I really appreciate your effort in producing this stunning video ❤

[@alan9171]

I think you need to update your videos?? i.e. topics?? where is that??

[@Khadija_work]

Thank you so much 💐

[@LearnitTraining]

You're most welcome!

[@alan9171]

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

[@LearnitTraining]

Hello Alan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

[@nikhilrao382]

"ctrl o" does not open active directory. Could you tell me how to do that?

[@LearnitTraining]

This article may help -techcult.com/how-to-enable-active-directory-in-windows-10/

[@neilmcnicol6506]

@@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.

[@yoganandgowda7275]

Please provide exercise files it would be greatful for beginners

[@TheHumanRanger]

Thank you! :)

[@LearnitTraining]

You are welcome!

[@ak891]

Please make a video on powerpoint also

[@LearnitTraining]

The full course one is coming soon!

[@PunyaritKlaphachon]

Thank you.

[@LearnitTraining]

You are welcome!

[@jurelebar9359]

How can I add an empty paragraph to word? Selection.InsertParagraph gives an error

[@LearnitTraining]

Hello Jure! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@KrishnaPatil-bc1kj]

were can i find the powerpoint used in the video, i cannot find it in the exercise files

[@ForeclosureGhost]

Good question, it wasn't in mine either.

[@SouravSolanki-ec5uh]

00:43:36

[@LearnitTraining]

👍👍

[@hubertz.6560]

how do I access the files you are using in the video

[@LearnitTraining]

learnitanytime.com/p/exercise-files-excel-2021-vba-full-course-tutorial

[@SouravSolanki-ec5uh]

00:43:36

[@LearnitTraining]

👍👍👍

[@MokhlisAbderrahim]

Thanks!

[@LearnitTraining]

Thank you so much MokhlisAbderrahim! Your support helps to continue making new videos each week!

[@Skill-tube]

🎉🎉

[@LearnitTraining]

🎉🎉

[@normwilliams3435]

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

[@po-yulin640]

There is a typo in your code. "ElseIf MRSP < 30000 Then" It should be: "ElseIf MSRP < 30000 Then"