VBA Macros single event (Enter & Exit) for multiple userform textboxes

Hello Again,

I have around 197 textboxes on a single userform. I am trying to change backcolor & Font color when enter the textbox. and again change backcolor & Font color when enter the textbox.

I have to write for each and ever textbox for enter/exit event. Can we have any solution to write single code for all the textboxes.

Please Login or Register  to view this content.

Youe will have to declare a class and add the relevant textboxes as members of that class

nigelog, you can't do that. Enter and Exit are not exposed using WithEvents. You need to use some very creative workarounds or copy and paste the code a lot!

Another option, though not much better, would be to create 2 subs & call them like

Please Login or Register  to view this content.

I found the below and it works for me after some minor changes. But still I have to write case statement for each and every textbox.

Declaration

Please Login or Register  to view this content.

On Userform

Please Login or Register  to view this content.

ClassModule - Name:CtlExitCls

Please Login or Register  to view this content.

@Kyle
Lol, glad I read that was wondering why it was not happening for me