Hello,
I stumbbeld upon McGimpsey's method to lookup a pic based on a cell's value. I got it to work for myself fairly easy. Yet I have not managed to
get it to work for multiple cells.
What I got to work:
If cell A2 contains a certain value a related pic appears.
What I didn't got to work:
If cell A2 contains a certain value a related pic appears and if cell A3 contains a certain value a related pic appears. But not necessarily the same
value an pic, but that could be possible, since the value in A2, A3 etc. is selected by a drop-down list through Data-validation.
The VBA-code I used:
I basically need an adjusted code which lets me choose a value en show a picture in an infinite number of cells, than only cell D1. I want the same function for other cells.Please Login or Register to view this content.
I already tried:
With Range ("D1";"D9"), but then both these cells just need to have the same value, and a picture is shown.
The Excel file I used is embedded in this post.
Thanks in advance!
Bookmarks