Photos in Excel linked to a folder using VBA

[MFish]

Hi,

I'd like to know two things...

One: Is there a way I can add something in a userform (button, textbox, etc.) where I can upload a picture from a shared folder? Once you hit submit to transpose the information on the sheet it will show either the picture or a link to open up that photo?

Two: If not, is there a way I can upload a link in a cell that will direct them to the folder and open the picture?



Thanks for the help.

 

[The_Macrotect]

Hi MFish,

If you right click on the cell you'd like the link to be and choose "Hyperlink", it will allow you to insert a clickable link to open any file (pictures included). After you choose "Hyperlink", simply browse to the desired file and choose the text you'd like to appear in the cell by typing it in at the top, where it says "Text to display:"

Does this do the trick?


All the best,
Matt