Pictures in dropdown lists
I'm designing a excel sheet with data validation dropdown lists and depending
on what product is chosen it will display a picture of the chosen product. As in when formatting a cell and choosing a picture !. Is this possible? |
Pictures in dropdown lists
http://boisgontierjacques.free.fr/pa...htm#choixImage JB On 14 août, 19:36, Woody wrote: I'm designing a excel sheet with data validation dropdown lists and depending on what product is chosen it will display a picture of the chosen product.. As in when formatting a cell and choosing a picture !. Is this possible? |
Pictures in dropdown lists
hi
maybe not a picture in the DV dropdown but you might be able to display a picture of a name in the dropdown. see this site. http://www.mcgimpsey.com/excel/lookuppics.html regards FSt1 "Woody" wrote: I'm designing a excel sheet with data validation dropdown lists and depending on what product is chosen it will display a picture of the chosen product. As in when formatting a cell and choosing a picture !. Is this possible? |
Pictures in dropdown lists
JB, THANKS VERY MUCH, EXACTLY WHAT I WAS LOOKING FOR.
"JB" wrote: http://boisgontierjacques.free.fr/pa...htm#choixImage JB On 14 août, 19:36, Woody wrote: I'm designing a excel sheet with data validation dropdown lists and depending on what product is chosen it will display a picture of the chosen product.. As in when formatting a cell and choosing a picture !. Is this possible? |
Pictures in dropdown lists
FSt1, both you and jb have hit the nail on the head, cant thank you both
enough... "FSt1" wrote: hi maybe not a picture in the DV dropdown but you might be able to display a picture of a name in the dropdown. see this site. http://www.mcgimpsey.com/excel/lookuppics.html regards FSt1 "Woody" wrote: I'm designing a excel sheet with data validation dropdown lists and depending on what product is chosen it will display a picture of the chosen product. As in when formatting a cell and choosing a picture !. Is this possible? |
All times are GMT +1. The time now is 05:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com