Can you fill a cell with an image?

[Muzza86]

is there a way to simply fill a cell with an image, rather than a colour?

[Ron Coderre]

Techically, images sit on cells...not in them.
You'd need to position the image so it fits withing the cell borders.

If that's something you'd consider, let us know your requirements.

[Muzza86]

complicated really.

I have 4 objects (rectangles) located on the left hand side of the sheet. I also have one big object (rectangle) on the right hand side of the sheet.

Basically, what I want to do is have 4 different images in the 4 objects on the left... and when the mouse hovers over them I want an image to appear in the big object on the right which corresponds to the image I am hovering over on the left object. so it changes every time.

and I need all this to happen, without clicking.

now I can do a rollover hyperlink effect on CELLS using just formulas.. but with shapes this obviously doesn't work.


can I code this??

[Muzza86]

any ideas? is this even possible?

or to be simpler (or more complicated I don't know) ...if I could make a shape change fill image when a cell changes value - that would work toO!

[shg]

...if I could make a shape change fill image when a cell changes value -

If the cell value is changed by data entry, sure -- you could do whatever you want in the Worksheet Change event.

[Muzza86]

can you please enlighten me then? if I had rectangle 1. and data in a1. what code what I need to make the fill of the shape change to a image and back when the a1 changes from 0 to 1 and back. without clicking

[Muzza86]

any example codes?