Displaying images using path name in cell

[darkmage1]

What I am trying to do is take image path data from a cell and have it automatically display the image when the spreadsheet is open. For example, let save the data in cell F2 is "C:\test\image.jpg" I would like to have the image automatically displayed when the spreadsheet is open. I gave it a lot of thought but I am not sure how to do this.

 

[TonyJollans]

Hi ChaoticEmpire,

If you want the picture automatically shown when the workbook is open what is the benefit over just having the picture there in the first place?

Only thing I can see is in the size of the workbook. Disadvantages, on the other hand, spring to mind - time taken to open, relative positions of other elements, inflexibility, macro security settings perhaps.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[