Selected Answer
Yes. It's possible. Here are some basics.
- Icons are pictures. You have lots of them in your PC but most of them are spread over many directories where the programs that need them can find them.
- You can display any picture in any cell. For that purpose you will need to know the picture file's address. You can use the existing addresses but you may find it easier to manage if you make copies of all the icons in one folder of your choice and use those copies in your program.
- You can dynamically select a picture depending upon any criterium, for example the contents or partial contents (file extension) of a cell.
- You can dynamically change the position of a picture on the worksheet, depending upon the content or partial content of a cell.
- None of the above relatees to Windows. All is can be controlled from an Excel workbook using VBA.
As you continue your planning, I suggest you pay special attention to the work flow. Don't plan on clicking any button to see action. Instead, your plan should be that the icons appear automatically as you select cells, pick items from drop-downs or enter key words or numbers.
So, for example, you start with creating a drop-down with file names. When the user selects a name a macro kicks in (a Worksheet_Change event occurs and that event triggers the macro) that shows an icon in a specified position. For the purpose of getting help, just ask for simple solutions of partial problems, like, how to display the icon, How to adjust its size to match the size of the cell, how to determine the display location dynamically, how to select a different icon for different selections.
In other words, start with the work flow to define questions. Then get the big picture before the detail.
