I have a series of textboxes that require the same code to be executed when the user tabs out of them. In order to save filling my VBA script with eventhandlers for each text box, I have used a public sub that is called by each text box. I then use the Screen.Activecontrol to identify the actual control to apply the logic to.
Sounds great, but for some reason, the code is triggered three times! Can anyone explain this as I am lost.
I have tried other events on the controls and it happens with all of them. Also, If I code the [Event Handler] then it is only triggered once. The problem seems to be limited to calling a public sub from multiple controls.
Regards
Dave
Sounds great, but for some reason, the code is triggered three times! Can anyone explain this as I am lost.
I have tried other events on the controls and it happens with all of them. Also, If I code the [Event Handler] then it is only triggered once. The problem seems to be limited to calling a public sub from multiple controls.
Regards
Dave