Multiple combo boxes - listbox populating

hi there, can someone please help me.
i am struggling to be able to fill the comboboxes with the data from my worksheet.
and i want the user to be able to make a selection from the first combo box, that will then fill the second combobox, and the second selection will put info in the textbox at the bottom, any help wud be great! thanks.

Hello Burgerboy2k6,

If I understand your post and worksheet, you want the category ComboBox, which has 1 and 2 init now, to then fill the Topic ComboBox with 1,2,3 for the category selected. and then put the information into the Info Listbox? Am I correct so far?

Thanks,
Leith Ross

yes thats correct, sorry i didnt word it that well.
but yea thats exactly what i want to do yea.

Hi

Try this. As the sample info contains numbers in columns A and B of Data, there are conversions to make the combobox results numeric not value. If your data isn't really numeric, then you will have to remove this conversion.

rylo

Aw thanks everyone that works great ta

rylo, sorry, which bit is the conversion that i need to delete to use text?

thanks

Doesnt matter thanks alot guys, thats worked really great! thanks