Insert jpg image from file path to image frame

Morning all,

I am tearing my hair out with this one.

I have a list of images saved on a server named 0001.jpg, 0002.jpg, 0003.jpg etc... etc...
The file path for these images is P:\Sales\Images\Nov 12

I have created a spreadsheet with a combo box (Sheet 1) that lists the image numbers and these are linked to cell A6. I have created a CONCATENATE formula in cell A7 so that it reads 0001.jpg etc...

I have also added an ActiveX Image control (Image 1) to the spreadsheet.

What I would like is for the user to select the image name from the combo box and for the image to be displayed in the Image control.

There must be a fairly easy way of doing this - but it's driving me crazy. Any help would be greatly appreciated.

Apologies, I can't upload a sample document as my company's firewall seems to be blocking it.

Thanks

Steve