Is it possible to write a simple code that apply to multiple objects in vba?

Asked Nov 27 '21 at 08:36

Active Nov 27 '21 at 08:36

Viewed 20 times

I have multiple textboxes (say 16) which I need to update a label with the sum of the said textboxes on the event of change. Do I need to write the same code (that calculate the sum) for each textbox's change event?

Or is there another way which I can apply the code to each object that is changed.

asked Nov 27 '21 at 08:36

A. choofe

Typical suggestion here is to use a Control Array: https://bettersolutions.com/excel/macros/vba-control-arrays.htm – Tim Williams Nov 27 '21 at 08:41

Is it possible to write a simple code that apply to multiple objects in vba?

0 Answers0