DRJ
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 3,853
I was trying to group together several textboxes on a userform to group together their before update events to check for proper values. Anyways I get to the point when I start a class module and put
Public WithEvents TextBoxGroup As TextBox
When I try to compile excel gets an error stating that the object does not source automation events. So can text boxes be grouped like this? I was able to do the same thing with command buttons and toggle buttons, but maybe there is a different way to do text boxes??
Public WithEvents TextBoxGroup As TextBox
When I try to compile excel gets an error stating that the object does not source automation events. So can text boxes be grouped like this? I was able to do the same thing with command buttons and toggle buttons, but maybe there is a different way to do text boxes??