Hi,
I am trying to have a picture in a imagebox(image1). The picture is , let's say, in folder C:/folder.
The full path (eg C:/folder/picture.jpg) is displayed in a cell(the imagebox(image1) is positioned over the cell). the cell is B7.
I am using vlookup and a dropdown(on another sheet in the same file) to change the filepath displayed in cell B7.
I can't seem to get the code right to get excel to show my picture from the displayed path in the imagebox(image1) and to chenge the picture when the filepath displayed in that cell changes.
Could be done just by vlookup and linked image, I know. But this would make my file larger. The file will be copied to the server at least 10x a day...
If anyone could help me code this I would be very grateful!
Bookmarks