Excel 2021 VBA Advanced Tutorial

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-vba-advanced-tutorial

[@frederickjackson7877]

Hi Trish, within the SUB GetDates under the Case "Other" both the StartDate and EndDate are declared Public As type Dates, However they are then assigned a String that creates problems
To overcome the problem best to amend to StartDate = CDate(txtStartDate) and EndDate = CDate(txtEndDate) in the SUB GetDates()
Trish your presentation and detailed explanation of Excel VBA is first class Thank you so much.
Fred

[@LearnitTraining]

Thank you for the tip Fred!

[@analuizanb]

That's because you already know VBA. She dumped a ton of code and didn't really explain anything.

[@alejandrocruz7869]

Title does say Advanced@@analuizanb

[@luqmanshah7942]

Hello. Are you guys going to release a course on Office Scripts, considering it was introduced to Excel Desktop not too long ago? I use VBA frequently at work, but I would love to learn Scripts to use in conjunction with Power Automate.
Thank you for all the learning resources.

[@LearnitTraining]

Yes! We are working on creating the course currently. Hopefully we can get it up soon!

[@salah_sinjer]

hello, I could not find the slides, I only found the xlxs files

[@byteseq]

"Public StartDate, EndDate as String" gives you one Variant and one String! Not two variables of type String! Common mistake

[@LearnitTraining]

Noted!

[@Oneshot54-v4u]

please share us adobe after affect

[@LearnitTraining]

Coming soon!

[@trulyarunachali]

Is their an intermediate tutorial

[@LearnitTraining]

Here you go: ua-cam.com/video/9SxjWg9UBiY/v-deo.html

[@brianyang1572]

Good morning ☀️

[@LearnitTraining]

Good morning Brian!