I use a textbox called date on a number of userforms. The textbox checks on exit whether the date is a holiday.. with some additional action.
I am an absolute beginner with class programming but it is my understanding that you can create a new instance of a class, with all the properties associated with the class.
Is it possible to create a textbox class called txtDate which checks for errors when the user exits the textbox?
I assume that the exit function would also need to be a class?
This would enable to me to reduce the code needed in my project .. most likely by 20% as I could then apply the same technique to other controls.
Isn't this the idea of class programming?
I have attached an Excel file with many userforms .. each with a textbox called txtDate
The function checks whether a date is a holiday.
I do sincerely hope that someone can help me with this.