Paul - I normally use MS Access for my development, but I often follow your TH-cam channel. By coincidence, the online Access Users Group recently had two demonstrations of WithEvents, so I was intrigued by your video. It took me a while to understand how to create an Excel User Form, but once I had it working, I was highly impressed by your work. I intend to see if I can implement the same concept in my Access projects. Thank you for posting.
Excellent, I wish you can do more real samples like this one using Classes in the future, I have noticed most tutorials cover very simple examples with no real /practical use.
Nice video. I like the stepped and structured way you explain advanced functions like withevents and classes. The demonstration in a practical application makes it even more stimulating to take the unsure step into trying something new that once mastered is so helpful. Great work! thanks.
Hi Paul, i would highly appreciate if you would create a video about writing own custom events outside of Userforms. Because i am curious about the benefits of creating own Events.
Incredibly useful video. I've heard of using Withevents before, but your explanation somehow makes it more accessible and understandable. What I understand (but you did not explain explicitly) is, that the method you present does not inhibit the normal event calls in the userform itself. I've been developing a userform application that has a lot of textboxes, comboboxes etc. So I decided to add a Help-textbox at the bottom of the userform that displays dedicated helptext. For this, I use the even _Enter(). That's indeed a lot of code that I can now replace with the class withevents. Thanks so much!
Great Video! So Usefull. A Suggestion for future videos is show some examples with custom controls with RaiseEvent method to create custom events, and how to deal with it in Form itself, when you use an array of objects.
Great video- class modules are awesome. But I have a question 13:57 is it a good practice to use the i variable as long since only 9 values are stored. Is it better to use in this case "as Integer" or even "as Byte"?
Hello, thank you for the video. I need help, please What should we do? If the site requires you to log in first, then scrape the data from it after that
Keep in mind that class that uses withevents must maintain its reference or the events will not fire. If you had declared the class locally in a method then the event fires after that method exits the reference will be destroyed and the code you've bound to that event will not fire. This has caused me hours of confusion and troubleshooting in the past so I figured I'd share it here.
@@Excelmacromastery Your code is great as usual. My only worry was that people will likely not be copying it verbatim but rather adapting the principles to their own project. In my case I was making a unique toggle button group and after adding the buttons to the group I knew I would never need to explicitly reference the group again but little did I know that these proxies are implicitly referenced and these "lite references" are not enough to keep the proxies from being destroyed when they go out of scope.
I am interested in algorithmic trading with VBA. Any tips? Do you know any websites or forums that focus on algorithmic trading with VBA that you would recommend?
How do you then access the properties of another For example of I wanted the user to type in textbox2 and the value appears in textbox1. I want to use similar experience, I created buttons when a user hovers over it, it changed color and when exits it goes back to the original color, I wrapped a textbo around the button to capture mouse movement when the user exits the button but this textbox can't change the properties of the button when in class module
I love your videos, but the searchable combobox could be done simpler. I know why you did it this way. But if you use a dictionary to filter and make the default list that way it does not glitches out and it is still fast enough, even with 30000 rows. And you have a combobox with all unique entry. And it is scalable to multiple combobox.
Yes. Even if VBA was replaced today there is still hundreds of millions of lines of code to be supported. That said there is no replacement for VBA right now. * Office Script can only do a fraction of what VBA does and it requires using Power Automate for events. * Python requires third party software to connect to the object model and installation can be problematic.
Thanks a lot. Class Module is so strong but not many person can explain as good as you.
Thanks Paul. You are one of my favourite teachers. I consider myself fortunate that you happen to teach a topic I have great interest in.
Thanks😀
You are genius. Definitely we want you to keep making such educational videos.
Paul - I normally use MS Access for my development, but I often follow your TH-cam channel. By coincidence, the online Access Users Group recently had two demonstrations of WithEvents, so I was intrigued by your video. It took me a while to understand how to create an Excel User Form, but once I had it working, I was highly impressed by your work. I intend to see if I can implement the same concept in my Access projects. Thank you for posting.
You're welcome Jack.
Again, this is an excellent explanation. I like every piece of information that you share. Thank you.🙂
Thanks for this informative lessons
Excellent, I wish you can do more real samples like this one using Classes in the future, I have noticed most tutorials cover very simple examples with no real /practical use.
Glad you liked it.
Nice video. I like the stepped and structured way you explain advanced functions like withevents and classes. The demonstration in a practical application makes it even more stimulating to take the unsure step into trying something new that once mastered is so helpful. Great work! thanks.
This is awesome. Great man... I really enjoy your video... Basic fundamental explanations from scratch, then project build-up...
Nice! You are at another level with your code.
Thanks
Great video!! Thank you. I am happy to use VBA.
Hi Paul, i would highly appreciate if you would create a video about writing own custom events outside of Userforms. Because i am curious about the benefits of creating own Events.
Incredibly useful video. I've heard of using Withevents before, but your explanation somehow makes it more accessible and understandable. What I understand (but you did not explain explicitly) is, that the method you present does not inhibit the normal event calls in the userform itself.
I've been developing a userform application that has a lot of textboxes, comboboxes etc. So I decided to add a Help-textbox at the bottom of the userform that displays dedicated helptext. For this, I use the even _Enter(). That's indeed a lot of code that I can now replace with the class withevents. Thanks so much!
Glad it was useful Martin.
Now that's a nice Xmas present...Cheers Paul
You're welcome
Very useful. Thank you
Well Explained
wow! this is something worth learning! :)
Great Video! So Usefull. A Suggestion for future videos is show some examples with custom controls with RaiseEvent method to create custom events, and how to deal with it in Form itself, when you use an array of objects.
Thanks. I debated including Raise events but in the end I thought it might lead to confusion. I may do a video on this topic in the future.
Wow.
Thank you very much
I love this and all your videos. Question, how did you add that "Statistics" button at around 15:55?
MZ Tools
Great video- class modules are awesome.
But I have a question 13:57 is it a good practice to use the i variable as long since only 9 values are stored. Is it better to use in this case "as Integer" or even "as Byte"?
Hello, thank you for the video. I need help, please
What should we do?
If the site requires you to log in first, then scrape the data from it after that
Hi, great tutorial! Is it possible to return to a class the name of the control that initialized this class?
Dear Paul , I usually use collection of Textboxes in Userform , my question is there any difference between Array and collection ?
Keep in mind that class that uses withevents must maintain its reference or the events will not fire.
If you had declared the class locally in a method then the event fires after that method exits the reference will be destroyed and the code you've bound to that event will not fire.
This has caused me hours of confusion and troubleshooting in the past so I figured I'd share it here.
Very true. That's why it is better to declare at the top of a UserForm so it can be used throughout that UserForm's lifetime.
@@Excelmacromastery Your code is great as usual. My only worry was that people will likely not be copying it verbatim but rather adapting the principles to their own project.
In my case I was making a unique toggle button group and after adding the buttons to the group I knew I would never need to explicitly reference the group again but little did I know that these proxies are implicitly referenced and these "lite references" are not enough to keep the proxies from being destroyed when they go out of scope.
I am interested in algorithmic trading with VBA. Any tips?
Do you know any websites or forums that focus on algorithmic trading with VBA that you would recommend?
How do you then access the properties of another
For example of I wanted the user to type in textbox2 and the value appears in textbox1.
I want to use similar experience, I created buttons when a user hovers over it, it changed color and when exits it goes back to the original color, I wrapped a textbo around the button to capture mouse movement when the user exits the button but this textbox can't change the properties of the button when in class module
The Class for Controls doesn't have Enter, Exit, BeforeUpdate, and AfterUpdate events. How can we get around for this? Thanks before, Paul..
I love your videos, but the searchable combobox could be done simpler. I know why you did it this way. But if you use a dictionary to filter and make the default list that way it does not glitches out and it is still fast enough, even with 30000 rows. And you have a combobox with all unique entry. And it is scalable to multiple combobox.
Do you think there will still be a demand for VBA programmers in the coming years, especially with the changing landscape and the rise of AI?
Yes. Even if VBA was replaced today there is still hundreds of millions of lines of code to be supported. That said there is no replacement for VBA right now.
* Office Script can only do a fraction of what VBA does and it requires using Power Automate for events.
* Python requires third party software to connect to the object model and installation can be problematic.