Forum Discussion
TRC10
Sep 26, 2023Copper Contributor
Dropdown list returning an image based on selection
Hi all,
Hopefully someone has a solution. I have created a list of people that when selected brings up some personal information but would also like it to return a headshot of the individual. Any suggestions or support on how I can achieve this would be great.
Thanks.
- Patrick2788Silver ContributorIf you have 365, you could use the IMAGE function.
https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5?ns=excel&version=90&ui=en-us&rs=en-us&ad=us- TRC10Copper Contributor
Patrick2788 thanks for the response, how would this work if the images are not web based? i.e. in a folder on the desktop?
- peiyezhuBronze Contributorhttps://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-use-the-image-function-with-local-images/e539c52e-fe3c-40d0-b0da-fcbcc16802b2
Run a web host on your PC to convert local images to urls.
https://github.com/FiloSottile/mkcert
making locally-trusted development certificates
or
https://support.microsoft.com/en-us/office/block-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795#:~:text=Dynamic%20Data%20Exchange%20%28DDE%29%20is%20an%20older%20Microsoft,want%20under%20Security%20settings%20for%20Dynamic%20Data%20Exchange%3A
allow extrenal links