Видео

Fear of globals feels like superstition.

Is there a reason you used all those variables rather than just write the textbox values directly into the cells? I realize that this is a video aimed at people just getting introduced to userforms but doing it this way actually seems to complicate things.

I have watched a number of videos on creating/using classes in vba and you have provided the clearest explanation that I've heard so far concerning how they actually work. Thanks.

Hi , would you share the excel file with us ?

thank you for explaining the get and let assignments when stepping through the code. I have read so many articles and books and I just didn't that concept that till you showed it step by step. soooooo helpful thank you!!!! i probably could have figured that out but there is so much i'm trying to figure out. your vids are incredibly helpful!!!

Great video and very easy to follow and understand. Thank you!

I really enjoyed the video, it is very cool!

I don't understand how the employee, person, and address get linked together in your examples. Can you please explain the specific aspect of your code?

Got all up and running without watching the closed captioning all the way. It's time consuming (turn on and off the CC so I can observe the codes while you people who can hear your voice

Jennifer - I have stumbled my way through class modules with a modicum of success but have never been quite sure. This is simply the best explanation! This has helped me fully bridge the gap in my knowledge from being a good coder in modules to being able to code class modules with confidence. I want to say a big thank you and, for anyone wanting to learn about classes, I will be sending them to your you tube videos.

hi there! how do you actually distribute this form?

Yes. It was helpful. Thanks.

Thanks Jennifer for creating this video

I was following along and making a "calculator" to figure out numbers till I hit Hexadecimal... lol. Then I had to use xlookup for a-e.... Thanks for the complete explanation.

Good to hear from you 😂

Thank you for this video

sorry Jennifer , but the explanation is really confusing especially with this unnoticed mistake you have made .

Your explanations and topics are great, and the highlight of your videos is definitely your infectious laughter.

Great video! It definitely gets some ideas going. Are you going to create a course or series of videos to show how to create a custom add-in?

Unique and interesting content. Goes through history with more than one perspective. Good luck 🤞

Excellent tutorial, like all your previous ones. Thanks for the great tip on how to prevent the compile errors pop-up. The loud alarm accompanying the pop-up was really irritating and whenever it happened, more often than not I would end up inadvertently clicking 'help' rather than 'close'. It meant having to wait for a really useless help textl to load and having to close an extra window. It used to rattle me every time. The whole thing had developed into a sort of phobia. Not exaggerating by saying that life has turned much easier because since I got rid of that pop-up. The silent red lettering is comparatively such a gentle and polite way to be alerted. Thank you ! 😊😅 p.s.You have an incredible voice.

Enjoy your videos young woman. I like that you seem to concentrate a bit more on the advanced features of VBA. 👍

Awesome video! I would LOVE to learn how to do this and how to add the combo box to the custom ribbon tab.

nice, well-explained, real-life coding, beautiful voice

Liked the video, but what are the advantages to using the "getters & setters" over just setting the properties as Public and validate data in code that creates the class?

I learned alot from you, thanks, really looking forward to your next video about qualification at 56:00😊

Excellent explanation! Clear and easy to understand. The details provided are very insightful and make the concept easily accessible for everyone. Great job

The way you explained "New" class was fantastic. ❤❤❤. Thank you.

Very informative

'Declaring enum Enum eEmployeeType eFullTime ePartTime eSeasonal eContract End Enum ------------------------------------------------------------------------------------------------------------------------ 'Main sub Sub Main() Dim employee As New clsEmployee With employee .FirstName = "Ousmane" .LastName = "Tall" .EmployeeType = eFullTime .EmployeeCase End With End Sub --------------------------------------------------------------------------------------------------------------------------- 'Declaring top variables Private pFirstName As String Private pLastName As String Private pEmployeeType As eEmployeeType -------------------------------------------------------------------------------------- 'EmployeCase method of the Class Sub EmployeeCase() Select Case pEmployeeType Case eFullTime: printEmployeeData ("Full Time") Case ePartTime: printEmployeeData ("Part Time") Case eSeasonal: printEmployeeData ("Seasonal") Case eContract: printEmployeeData ("Contractual") Case Else: MsgBox "Not defined", vbInformation, "ERROR!" Exit Sub End Select End Sub ------------------------------------------------------------------------------------ 'Set public properties of the Class Public Property Get FirstName() As String FirstName = pFirstName End Property Public Property Let FirstName(ByVal sFirstName As String) pFirstName = sFirstName End Property Public Property Get LastName() As String LastName = pLastName End Property Public Property Let LastName(ByVal sLastName As String) pLastName = sLastName End Property Public Property Get EmployeeType() As eEmployeeType EmployeeType = pEmployeeType End Property Public Property Let EmployeeType(ByVal eType As eEmployeeType) pEmployeeType = eType End Property 'Calling one subroutine of all the job status Private Sub printEmployeeData(jobDefinition As String) Debug.Print FirstName, LastName, jobDefinition End Sub -----------------------------------------------------------------------------End so all the job is done!

Great video, but you could ommit using the gets property, since you haven't need then in this project, or if you really want to use them, instead of calling the pFirstName, pLastName etc, you have to call the function get FirstName, get LastName etc rather, to run them in other hand

❤❤❤

I believe this is an example of composition, which is an alternative to inheritance. Hope you can make some more similar videos and show if / how SOLID principles apply in VBA too.

Great!, Also Please share this sheet if possible. Thanks for the videos

Was able to follow explanation but disappointed that you didn't bother to show how to do the replace command or run the sub after it was entered. You showed it being run from the spreadsheet but I was only able to run it from the vba editor after playing around for some time. And ir would have been nice to see how it could have been used in the spreadsheet. I probably didn't understand this tutorial was not meant for beginners. Jerry

Hi Jenifer, thank you for the video. Though you're a newby in VBA youtuber it was what I have thought others should create to convince learners of classmodue. I guess I will subscribe you and share some ideas regarding VBA.

HI Jen. How Can you assign a String Value to enumerations. I.E. Public Enum eNumName eFirstname = "Jen" eLastname = "Garth" end enum

666th Sub!

Why didn't you use a Private variable for the class for the select case peEmploymentType. where the variable would have been set going through the select case. IE empolyeeType = FullTime. Then just have 1 sub PrintForms that would be called after the select case. Private Sub PrintForms Debug.Print pFirstName, pLastName, employeeType end sub

Classy lady 👍

VBA = Visual BASIC for Application BASIC - Beginners All purpose Symbolic Instruction Code

It is really interesting! I’m in for the course!🎉

this has been the best video on creating class modules and objects yet, easy to understand thanks

Welcome Back

Please do the course. I am really interested 😊

It is very interesting, I have bought some courses in VBA but none so far included API calls

It’s been a while for sure, thanks for this demo

Another brilliant module! One of the best explanations of regular modules vs classes I have seen

Brilliant! Please do more videos on classes