lehgzil
09-20-2010, 02:12 AM
hi im new here, and new to vba for excel also,
im making a project on which i have multiple comboboxes which are link to the previous combobox(eg combobox1 link to combobox2 which is link to combobox 3 and so on.) and that the value of the later comboboxes are dependent on the previous.
on this example i shortened the list of comboboxes to two.
i have a button called Produce, bringin userform1 with 2 comboboxes and 2 command button.
i need a code that generates value of combobox 2 if i selected a value to combobox1.
an example is attached...
btw i tried if and else and case select, it didnt work or theres something wrong with my code.
i appreciate your help. thanks in advance.
im making a project on which i have multiple comboboxes which are link to the previous combobox(eg combobox1 link to combobox2 which is link to combobox 3 and so on.) and that the value of the later comboboxes are dependent on the previous.
on this example i shortened the list of comboboxes to two.
i have a button called Produce, bringin userform1 with 2 comboboxes and 2 command button.
i need a code that generates value of combobox 2 if i selected a value to combobox1.
an example is attached...
btw i tried if and else and case select, it didnt work or theres something wrong with my code.
i appreciate your help. thanks in advance.