Popup Image when the cell value is equal to part of the filename

[yongshun]

I have few hundred data (product ID) and I have graphs for each of the data.
I saved these graphs as png in a designated folder.
The filename for the graph is "productID1 - productID2" because I wish to compare the data for 2 products.
I wish to use VBA code to popup the image when I click on the cell even the cell contain productID1 only.
Can anyone help me?

 

[HackSlash]

This is a large multi-part solution. Nobody wants to write the whole thing for you. You're going to have to get started and let us know when you get stuck.

My recommendation:
Use a VBA form and not worksheet objects. It's endlessly more difficult to work with worksheet objects because their ID changes. It's impossible to reference them.

Here is the basic outline of how I would do it:
1. Worksheet_SelectionChange event on the sheet with your product ID
2. Detect if the cell clicked is in the product ID column, if yes:
3. Open the VBA form object.

Then within the Form Object code:
1. Load the picture in to the form dynamically based on the selected cell

 

[Nine Zero]

+1 on the above