Excel 2021 VBA Full Course Tutorial (6+ Hours)

[@DAGenao]

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

[@LearnitTraining]

Thank you for the kind words!

[@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!

[@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!

[@christopherbond5846]

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.

[@louieandrofuertes9146]

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

[@LearnitTraining]

Thanks! We hope you learned a lot!

[@junaidtanoli6000]

Great initiative trish.explain to the point and concise.

[@LearnitTraining]

Thank you for watching!

[@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!

[@JamesWray-r9b]

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

[@farzadshirani7324]

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

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

[@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?

[@animust482]

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

[@letmedie4you]

very well expained and structured course . Thanks for your efforts

[@LearnitTraining]

Most welcome!

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

[@MokhlisAbderrahim]

Thanks!

[@LearnitTraining]

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

[@GiangPham-fw9kf]

I really appreciate your effort in producing this stunning video ❤

[@niyanaknowledgecave3277]

excellent!! i am in here, let's start...

[@LearnitTraining]

Hope you learned everything you needed!

[@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!

[@rahulagarwal7182]

Thanks for Hard Work ..Appreciate that God Bless You .

[@LearnitTraining]

You are welcome!

[@sanj6576]

1:47:42 starts VBA Intermediate

[@LearnitTraining]

Great timestamp!

[@yuszarinar]

Hi.. what is the different using excel formula in excel and using sub procedure If.. Then

[@frankblancoh7256]

Excellent!!!!!

[@LearnitTraining]

Many thanks!

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

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

[@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/

[@kebincui]

Excellent. thanks for sharing

[@LearnitTraining]

Youare welcome!

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

[@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!

[@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]

👍👍👍

[@ak891]

Please make a video on powerpoint also

[@LearnitTraining]

The full course one is coming soon!

[@MyBWR]

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

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

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

[@TheHumanRanger]

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

[@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"

[@alan9171]

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

[@fahadalqarni2068]

Why

[@Skill-tube]

🎉🎉

[@LearnitTraining]

🎉🎉

[@SouravSolanki-ec5uh]

00:43:36

[@LearnitTraining]

👍👍