VBA to tell shape to fill with image when a certain cell = 1

Guys,

Still in need of a simple VBA that tells the shape to change fill to an image I want, when a certain cell equals "1".

e.g. lets say:


a1 is the cell that I will change to "1"

shape = "rectangle 1"


I can successfully do a formula that will make the shape change WHEN CLICKED but I need it to happen without any clicking, just as soon as the cell changes its data to "1"


I have been trying things like:

Please Login or Register  to view this content.

but this only works (if all!) when it is CLICKED


help

sorry. correction: THIS is code I used.....

Please Login or Register  to view this content.