grouping multiple textboxes on a user form

**Obfuscated** · 03-27-2013, 04:06 PM

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,

Please Login or Register  to view this content.

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.

**Norie** · 03-27-2013, 04:09 PM

Is that code for one of the textboxes?

If it is why do you only go up to L_20 when there are 70 textboxes?

**Obfuscated** · 03-27-2013, 04:35 PM

70 was a quick guess. There are 40, 20 in one group, and 10 in each of 2 other groups.

And yes, each textbox has an individual "sub" to check for changes. That's what I want to reduce.

Like one array for the "L" group, one array for the "pat" group and so on.

**Norie** · 03-27-2013, 04:58 PM

Sorry you've kind of lost me.

Don't you know how many textboxes you have?

Do you need to 'group' them?

If there is some sort if naming convention could you not use that to determine what to do?

What is it you want to do anyway?