Hello Excel Masterminds,
I'm currently working for a small company that often needs to put about 100 photos into an Excel sheet. About a week ago in a separate post a generous user helped me to build a data validation system so we can simply select the photos from the drop down menu. I extended the system so it is on all of our pages and works like a charm.
However, as I learn more about macros and data validation I was wondering if it is possible to go the next step (when you give an excel newbie a short cut.... ). The drop down menus in the template I built will always automatically select for the name of the correct photo. That is the photos are named A1, A2....B1 B2 ect...and my team will name the photos to match the space on the menu. Even when I swap in a completely new photo folder the list still auto selects the correct photo as long as the naming scheme is consistent (which is always will be).
Given those parameters, is it possible to create a macro, or some sort of VBA code that will simply insert all the photos when run? Currently we just have to select the drop down and press enter, but if something did that for all the drop down menus on a sheet, that will speed up the process even more. If that's not possible or practical, please let me know. I'm here to learn!
Here is a sample workbook. Let me know if you have any questions and thank you in advance.
Bookmarks