Picture when combo box is changed

[bugmenot]

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)

Sub TEST()
'
' TEST Macro
'

'
    Range("M4").Select
    Sheets("Products").Select
    Selection.Copy
    Sheets("Quotes").Select
    Range("M4").Select
    ActiveSheet.Paste
    Range("N4").Select
End Sub

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 -

Private Sub Worksheet_Change(ByVal Target As Range)
If L4 = 1 (1 is the value that comes from the combo box) Then
        TEST
    End If
End Sub

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 =)

[batesie]

Ok it is uploaded here - http://www.2shared.com/file/6481238/...CT_IDEA-6.html

Donkey its the one with assign macro...

[DonkeyOte]

Sorry, I'm confused - 2 different members ?

Also please upload files here directly.

[batesie]

Sorry, I'm confused - 2 different members ?

Also please upload files here directly.

Yeah sorry, was my mates account...

Ok, i think i've managed to attach it now

[batesie]

any help...?

[royUK]

Take a look at the example database form here

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

[Swastik Banerje]

You may like to check this link

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

[batesie]

Thanks guys, i've seen the jkp-ads one before, but never been able to make it work... would anybody who knows what its about mind having a look at my sheets and change it so that it works...?

[Chance2]

Is this what you wanted?

No code, just copied a cell and Pasted as Picture Link (off the Paste Menu).
Changed the name of the Picture Link to your named range (PictureList).
And fixed your offset to only pull one cell/picture (no height or width).

[batesie]

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 =)

[DonkeyOte]

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.