Hi folks,

I have a user form that has about 70 text boxes for individual entries. They all respond to a "Change" event, and they all go to a single macro that re-figures the entire form. I currently have, 

Private Sub L_0_Change()
update_all
End Sub
through Sub L_20_Change()

Is there a way to make 3 groups or arrays that will look for these and send them to the update macro?

The reason for 3 is that 1 uses L as the start of the name, another uses pat_1 through pat_10 and another uses textbox1 through textbox10.