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.