Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
Multiselect Listbox - identify if item picked | Excel Programming | |||
Identify last item in a list | Excel Discussion (Misc queries) | |||
Add item to comboBox "form" from vba | Excel Programming |