I am trying to identify a particular Combobox on a form.
There is 21 in total(cmb23-43)

If a particular value is selected fromt he combobox, then another
userform(5) is shown.

The user then inputs a numeical value and click OK.

Using the commandbutton to OK, i need to identify what combobox triggered
the Userform5 to open, so i can then have the correct item updated.

EG. If Combobox23 value was changed and triggered the Userform5, then the
value entered into Userform5 would then be (Label1.caption =
Userform5.Textbox1.value)

If Combobox25 value was changed and triggered the Userform5, then the value
entered into Userform5 would then be (Label2.caption =
Userform5.Textbox1.value)

and so on .....................


I do not want to have 21 identical Userform's to input a value, but want to
be able to use the same Userform5 for all 21 Comboboxes.

How can i do this with the Userform5.CommandButton1_Click Event, to identfy
what Combobox was changed to then update the correct label on Userform1 ?



Ctm