something like this
Code:
for i = 1 to 15
with userform.controls("Combobox" & i)

Code:
Private Sub ComboBox1_Change()
.
.
.
.
userform1.textbox1.value=ComboBox1.List(ComboBox1.ListIndex, 3)