Display Image Based On Image Name In Cell

I have 8 images and when their name is displayed in a cell Sheet1!C3 I want the image of the same name diplayed in sheet 2. I searched around and found a topic using an image control but couldnt get it to work, I am using Excel 2007 if that helps.

Can anyone help me with a simple(ish) answer

Thanks in advance

Hi all

I have solved the initial problem with the code below

Private Sub Worksheet_Change(ByVal Target As Range)
If Target <> Range("A1") Then Exit Sub
Select Case Target
Case "#1": Image1.Picture = LoadPicture("c:\images\1.bmp")
Case "#2": Image1.Picture = LoadPicture("c:\images\2.bmp")
Case "#3": Image1.Picture = LoadPicture("c:\images\3.bmp")
End Select
End Sub