Can I Lookup Different Photos from within Excel
The VBA solution provided by JE McGimpsey is the generally accepted best
approach: http://www.mcgimpsey.com/excel/lookuppics.html (There is an alternative non-VBA solution, though.) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: I have created a worksheet that will provide sales details for 30 different retail locations. I select the store number and then the sheet poplulates with all the individual data from a database contained in the workbook. Now I would like to have a different photo displayed on the same sheet that coorelates to that store. I have 30 JPEGs and haven't been able to figure out how I can get the image to switch when I select a different store. Is this even possible. I know it can be done in Access but I am attempting to keep this project in Excel. The only other alternative I have is to create 30 different tabs (one for every store) and put a different photo on each tab. Not a very friendly alternative because changes would be a pain. This sheet already has five graphs that dynamically update. Can anyone help. Steve |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com