Based on the text in the cell, we created a template to insert a picture into another selected cell with VBA codes. Pictures are in the same folder as the workbook. The picture is fitted in the cell where it is inserted. When the added picture is clicked, it is displayed in its original size.
Source for details and sample file : VBA insert picture based on cell value
