Picture when combo box is changed

Hey guys,

This is the first VBA project i've done on Excel, and its not very big. I've never done any programming before, but i need help on this

What i'm trying to do it to have the Combo box that when an item is selected the respective picture shows next to it (i've got a seperate sheet with the products, prices, pics etc...)

After trying everything to get the picture to show, i switched to VBA because it looked like i could do it in that. The first thing i did was record a macro for each picture - the first one goes like this (its called TEST)

Please Login or Register  to view this content.

The first problem i had was with Sheets("Quotes").Select - for some reason it didn't like it and gave me an error. After some googling I solved it.

Now the problem i've got is with the Worksheet Change (is this the right thing to use?)

This is what i've got -

Please Login or Register  to view this content.

Correct me if i'm wrong, but this should run every time something is changed on the sheets?
Nothing happens when I select the first value in my combo box.

Any help would be great

Thanks =)

When you say ComboBox - are you using Forms Control or Active X Control - if in design mode you right click on the ComoBox do you see option to "Assign Macro" or not ?

It would be helpful if you could post a sample file.

Sorry, I'm confused - 2 different members ?

Also please upload files here directly.

Take a look at the example database form here

http://www.excel-it.com/vba_examples.htm

You may like to check this link

http://www.jkp-ads.com/articles/ShowPicture00.asp

Yes thankyou, that is exactly what I need =)

Can i ask exactly how you did that?

Oh and is there any way to make more than one, as i will need about 10 and the pictures will be in the same colum... :S

Thanks

__________________________________EDIT_________________________________-

Never mind, after experimenting with the name manager I managed to do it

Thank you very much Chance =)