Identify what Combobox was changed to update the correct item on the previous Form
 

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

Identify what Combobox was changed to update the correct item on t
 

hi
what code calls userform(5)? code in combo box?
if so then you might be able to use a little trick i have use in the past.
put a small text box on the main form, hidden so that the user can't see it.
then have the combo box code put it's id number in the hidden text box.
the code in commandbutton1 can then do a select case based on what id number
is in the hidden textbox.
there may be other ways but i have used this trick before and it works.

Regards
FSt1
"Corey ...." wrote:

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

Identify what Combobox was changed to update the correct item on t
 

FSt1,
Cheers.
Your idea worked for my problem.

Thanks


"FSt1" wrote in message
...
hi
what code calls userform(5)? code in combo box?
if so then you might be able to use a little trick i have use in the past.
put a small text box on the main form, hidden so that the user can't see
it.
then have the combo box code put it's id number in the hidden text box.
the code in commandbutton1 can then do a select case based on what id
number
is in the hidden textbox.
there may be other ways but i have used this trick before and it works.

Regards
FSt1
"Corey ...." wrote:

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