Multiple Comboboxes one click

[slim1313]

Hey All,

I have 2 comboboxes created on a userform.

This is my code for both of them

Please Login or Register  to view this content.

I want to be able to populate combobox2 when I select the combobox1
so when I click on Advise on Parrs I want 1 to come up in the combobox2

how do I do this?

[Leith Ross]

Hello slim1313,

The code below will load Combox2 with "1,2,3,4" when the item "Advise on Parrs" is selected in ComboBox1. All code is for the UserForm.

Please Login or Register  to view this content.

[slim1313]

It loads perfect, but I want it to automatically select I dont want to have to go and pick 1,2,3,4 and so on
is that possible?

[protonLeah]

From your description of what you want, it seems that your second box would be a textbox vs. a combobox. If so, then

Please Login or Register  to view this content.

otherwise

Please Login or Register  to view this content.

[slim1313]

sorry proton Leah that does not work
see I used 1,2,3,4 as an example, they will have unique numbers that are not in order there has to be a way to be able to populate 2 comboboxes just by selecting 1. or selecting and item in the combobox and having a specific number pop in a textbox

[Leith Ross]

Hello slim1313,

Where does these numbers come from?

[mikerickson]

If you want the selections of the two lists linked, would a 2 column combobox work?

Please Login or Register  to view this content.

[slim1313]

I can do the 2 column combobox, it looks ok, is there any way to populate maybe a textbox with the number associated to the selection

So I pick Advise on parrs and the number 3 pops in a textbox?
or I pick Escalation and the number 435 pops in a textbox?

Leith I have given the selections a number myself, they are not consicutive, so one can be 1 and another can be 75

[tigertiger]

I can do the 2 column combobox, it looks ok, is there any way to populate maybe a textbox with the number associated to the

Why don't you use 2 listbox?

When you double click item in list box1 --> it will be moved to listbox2

[slim1313]

dont know how to code that with 2 listboxes

[mikerickson]

I can do the 2 column combobox, it looks ok, is there any way to populate maybe a textbox with the number associated to the selection

I would use a Label rather than a TextBox (the user can't change the list so there is no need for a textBox)

Please Login or Register  to view this content.

[tigertiger]

dont know how to code that with 2 listboxes

Please, you can see the code under the link
http://www.theopensourcery.com/vb12tut.htm

a good code-exmple to your issue, I think that

[mikerickson]

I had one other thought. Are the 1,2,3 in this a simplification of the data? Or do you want to link the index of an entry with it's being selected?
Have you looked at the .ListIndex property of a comboBox?

[slim1313]

"I had one other thought. Are the 1,2,3 in this a simplification of the data? Or do you want to link the index of an entry with it's being selected?
Have you looked at the .ListIndex property of a comboBox? "

Yes link the index would be great can someone point me in the correct direction with the code?