Look up the result of a previous combobox

[crinkle]

Hi
I have a user form with various combo boxes each showing the result of the previous combo box selection, what I am trying to do is show (look up from my data) the description of a product that has just been selected in the last combo box is this possible? Also (I maybe asking the impossible here!) in my data I have a file path to the image that is associated to that product, will it be possible to display the image on the user form of the product that has been selected as well as the description? All my images are all together in 1 folder on my computer. If someone has any ideas I would love to hear them.
Thanks
Chris

 

[Andrew Poulsom]

Say your ComboBox uses a list of products from A1:A10 and the product descriptions are in B1:B10. This will put the description in TextBox1:

Private Sub ComboBox1_Change()
    TextBox1.Text = Worksheets("Sheet1").Cells(ComboBox1.ListIndex + 1, 2).Value
End Sub

You can use LoadPicture to change the picture in an Inage control:

http://www.mrexcel.com/board2/viewtopic.php?t=227166

 

[crinkle]

Hi
Thanks fore that i will try it out tomorrow.
thanks again
Chris

 

[crinkle]

Hi tried this and it only worked to a degree, my combo boxes work from named ranges as there is so much product and combinations this will only give me the descriptions of the first range on the work sheet. I need it to look up the description for any result in the last combo box from any named range i select, is there anyway of doing the last suggestion but look within named ranges? if that makes any sense.
Thanks
Chris