Replace path by cell reference

Hi,

I am using the following code to display images by click on the corresponding image titles in column C on sheet3.

This works fine so far but my problem is now that the path that is set in the code can change depending on certain criteria which can lead to 3 different options for the path.
Whereas it was no problem to replace the path in the module by a cell reference the same doesn't work for the code for sheet3.

Can anyone help me to find a way here that I can also define the code for sheet3 in a cell OR that I can set 3 different pathes in the code itself - please see the example worksheet attached ?

Code from Sheet3:

Please Login or Register  to view this content.

Code from Module:

Please Login or Register  to view this content.

Thanks in advance for any help with this - it is urgently needed !

Regards,
Mike

Hi,

I posted this under a new thread (Question on IF - THEN) in order to describe it better and will close it here.

Thanks,
Mike