Dear Forum,
Finally Got It,
Eureka...
It was so simple but just got complicated with me strangely and importantly its NON_VBA simple NAME ranges and Data Validation List and Camera Tool...
Just for the readers to make it useful..
1. Create a list of Picture Names and Pictures Next to it in the adjoining column in a Sheet renamed as Picture Database
Ex:- Col A - Picture Name & Col B - Pictures.
2. Remove any Borders and Remove Gridlines in the above sheet..
Name - >
3. In any other sheet named Selection - create a simple dropdown with the List of all names as shown below:
Name - >
4. Select any cell with a Picture in it the Picture Database sheet and then click on the Camera Icon in Excel 2007 and then paste in the Selection sheet in a cell where you owuld like the dynamic pictures to appear and immediately rename it to Picture.. if you have de-clicked it please click again and the formula toolbar just add as =Picture and there you go..
5. Try selecting any other name and you would get a different picture for every selection..
Wow..So cool....
Regards
E
Bookmarks