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:
but this only works (if all!) when it is CLICKEDPlease Login or Register to view this content.
help
Bookmarks