Is it possible to create sub for the same event but for several objects??

Hi,

i have 9 buttons on the User form. There are actually 9 lines of objects:

txtPart1, txtQty1, txtUnit1, txtTotal1 and btnDelete1
txtPart2, txtQty2, txtUnit2, txtTotal2 and btnDelete2
txtPart3, txtQty3, txtUnit3, txtTotal3 and btnDelete3
txtPart4, txtQty4, txtUnit4, txtTotal4 and btnDelete4
...
...
txtPart9, txtQty9, txtUnit9, txtTotal9 and btnDelete9


where all objects with leading "txt" are textboxes, and btnDelete(i) are command buttons.

My question is if it is possible to make one sub for btnDelete(i)_click that depending on which commandbutton was clicked, change properties of those textboxes in the same line. Or just need to make 9 subs for each command button?

My code for one button is:

Please Login or Register  to view this content.

And what, the same code I should repeat for each button? There should be some other way..
Pleeeease help me out with that..

btnDelete(i)_click is not correct. Try attaching a workbook so we can understand what you mean

Your best bet will be to use a class module for this, or alter your form layout completely and use a listbox.
A sample workbook would definitely make life easier though.

Click the 'Go Advanced' button, then click 'Manage Attachments', then follow the instructions. (see the FAQ here)

Here's a picture of a class module that should help.

If you provided a sample workbook, I would provide the actual code, instead of a picture...

Here you go.

Glad to help.
Using a class also has the advantage that if you need to add an event for all the Total textboxes for example, you can just add one event to the class (and declare the textbox variable WithEvents in the class), rather than adding it to all the textboxes on the form.