VBA change Picture 1

[theta]

Hi

I have an image on my workbook (tab called 'Section 1'). The image was just pasted into the workbook.

I need to make it so that when I change the selection of a data validation dropdown (client 1, client 2, client 3)...the image will change.

The logos are stored in the same dir of the workbook, in a sub-folder called 'Images'

So when 'client 1' is selected, named range of 'Selection' becomes 'client 1' and the VBA changes the picture to .\Images\client 1.bmp

Any ideas, better suggestions, examples?

 

[theta]

Sorry had to make a small change, otherwise it would fail when any other cell had its content deleted.

This adjustment works :

    If Target.Address <> Range("UserClient").Address Then Exit Sub
    If Len(Target.Value) = 0 Then Exit Sub