How can I make changes from more than 1 Textbox/Combobox?

[bralew]

Hi,

I have the following code that i would also like to conveniently execute from ComboBox20(and possibly more). I have enquired about this previously and had a great solution from xlnitwit.
However, I potentially have many of these to change and don't want to re-title lots of code. Any ideas??

Please Login or Register  to view this content.

[Arkadi]

bralew,

One option is to add the textboxes that should behave this way to a class.
That way you can trigger the same event for a number of textboxes.

However... it means that they all follow the same logic... you can make all textboxes check the text of combobox20 and then do math by multiplying their own number by the value, but if combobox20 changes text then how do you know which textbox's value to multiply to update 36?

But maybe I'm just not understanding exactly what should be happening.

[bralew]

I can copy this code and simply place it in ComboBox20, and in some code I have and it works great. However, this has considerations in terms of maintenance and I'd rather update one
area as opposed to multiple.

[bralew]

A class, that sounds interesting?

[Arkadi]

Agreed, but what I mean is...
When textbox 15 changes, 36 is updated depending on value of combo20.
You want to add more... but would they always check 20 and update 36 based on 15?
If it is always the exact same calculation then just make a sub called something like "sub update36()" and then just use "Call update36" in each of your change events... that way you only need to maintain one piece of code.

Class modules can be handy, but it is overkill if you always just want the same calculation based on the same items.

[Arkadi]

If the calculation in question is based on the box that changes, meaning if textbox 15 changes something happens based on its own value, and then if 17 changes, then the same thing happens but based on the value of 17, etc, then class modules can become helpful. If that's the case let me know and we can go over an example of what you would do.