Here's a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here's the solution! Here's a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here's the solution!


NB: This is an adaptation of a trick found on the book "This Isn't Excel, It's Magic" by fellow Excel MVP Bob Umlas. The book can be found and bought at/from http://www.amazon.com/This-Isnt-Excel-Its-Magic/dp/0970827652/ref=sr_1_1?ie=UTF8&s=books&qid=1234097616&sr=8-1