Filling two ComboBox Depending On Another ComboBox and ...

[iscar_marius]

Hello,
I want to fill two Combobox (cmb 2 and 3) dependent on what the user has chosen in a first ComboBox (cmb1).
The first combobox ist based on on the first sheet, and the second and third combobox shall be filled with values from other worksheet corresponding on combobox 1 selection.

I attached a xls to this post to explain better.

Please Help! this excel will save me a lot of time!
Thank you very much!!

[iscar_marius]

I really need to make this working !
Please give me an indication or something ...

[royUK]

Search for dependant comboboxes there are several entries here

[iscar_marius]

Thank you for your answer!
I don't know if dependant comboboxes it's what I need, or I can't see how I can use it.

[royUK]

Thank you for your answer!
I don't know if dependant comboboxes it's what I need, or I can't see how I can use it.

That's what you seem to askfor originally, take a good look at the examples

[iscar_marius]

I found an excel file, but I don't understand how it's working.
I had attached it to this e-mail!
Can you give me a clue ?
How can I change, for example, "bikes" with "food" ... ?

Please Login or Register  to view this content.

[royUK]

You need to change the categories listed in the yellow cells.

Each list item is in a Dynamic Named Range, so you need to add names for your selections & list the items in them.

Please Login or Register  to view this content.

[royUK]

You need to change the categories listed in the yellow cells.

Each list item is in a Dynamic Named Range, so you need to add names for your selections & list the items in them.

Please Login or Register  to view this content.

[iscar_marius]

Thank you very much! now I am a lot closer to finish my excel file!
I have another question, how can I do this:
when I select a value from combobox2 I need a coresponding value to a desired cell ?

I had attached a new, modified, .xls to this post!

I tried to modify the code, but it doesn't work how I need it!

Please Login or Register  to view this content.

Also I want to appologize for my english

[royUK]

Can you stick to one question per thread. You have yor code in th wron combobox.

I think this is what you want

Please Login or Register  to view this content.

[iscar_marius]

For the future I will stick one question per thread !vSorry!
Thanks for your answer but it's not what I need!
Actually I need something like this:
for example if I select st7 in first combobox and a2 in the second combo, the result should be 2.
I need the value from the right of the combobox2 selection.

st7
a1 1
a2 2
a3 3
a4 4

[royUK]

Try this

Please Login or Register  to view this content.

[iscar_marius]

Try this

Please Login or Register  to view this content.

Not exactly what I need

column1 column2
st7
a1 1
a2 2
a3 3
a4 4

for the above example the code it's ok, but my second column it's something like this:

column1 column2
st7
a1...............43544,6
a2 ..............36355,4
a3 ..............65789,9
a4 ..............32452,5


Thank you for your time!

[Xrull]

Iscar_Marcus
I've uploaded a file. Warning: I got this solution from someone, and put some pieces together and it worked (if I understand what you want).
Why did I do it? I used to work on my old VW, and sometimes I got it to work (or the engine blew up and cost me a "four letter scatological reference omitted" load of money to get it fixed ) when I tinkered with it.
Probably an expert can step you through the code. Why? I'm still trying to understand the code myself.
Regards,
Xrull

[iscar_marius]

Thanks a lot, this it's exactly what I was looking for !

[Xrull]

iscar_marius,
One more thing...the boxes self-populate when you add another row.
Xrull

[Xrull]

iscar_marius,
One more thing...the boxes self-populate when you add another row.
Xrull