Reply to thread

Message: [QUOTE="GS, post: 7393346"] If you use a lot of controls on a userform, a class module to handle them is probably a better way to go since it can handle controls as if they were an array. IOW, one procedure for all textbox controls versus a separate procedure for each. Optionally, you could have all textboxes call a single procedure and pass itself as the control object. The called procedure can divert action via a Select Case construct based on which control is calling it. This would obviate the need for a class handler and its associated overhead. I also made a separate reply about using a worksheet as a way to duplicate what you might use a userform for. [/QUOTE]