Making referenced pictures disapear when input cells are empty

I am very close to being finished, but need a little more help.


Looking at the attached spreadsheet.....

I have code set up in the 'OVERALL' tab as well as Module1 that allows me to display a given picture based on the information in columns R and S. (R and S are combined in column AZ, and rows 28 and 40 are doing a Vlookup using this information)

This is working great! The only issue I have is that a picture is being displayed regardless of whether there is information or not.

I want to 'NOT" display a picture if column AZ's value does not equal any of the pictures listed on the 'REF' tab.


(Note: I have only added pictures for the P2 configurations right now.)


As always, any and all help is greatly appreciated.

Regards,
Shawn

Here is the code in module 1

Please Login or Register  to view this content.

I assume that I need to change this line "On Error Resume Next", but I'm not quite sure what to change it to.

I assume it needs to be "On Error Goto ....." and then put in another section of code that bypasses the picture process.


Am I going in the right direction?

Originally Posted by Leith Ross

Hello fourwhls,

I am not sure about how you want these pictures displayed. Currently, they are all in a single row and the designations are in column "AZ". Is a picture to be visible whenever any single designation for that picture appears in column "AZ"? Is it to remain in its current position in that single row?

The pictures need to stay in their respective location, as they are now.


To answer the other question, I will list some scenarios....

If AZxx= R2RL ------> The R2RL picture will be displayed
If AZxx= R2__ ------> No picture will be displayed
If AZxx= __RL ------> No picture will be displayed
If AZxx is blank ------> No picture will be displayed


I hope that makes sense.