still cant make a shape fill without clicking

[Muzza86]

for this example.. think of this information:

shape = rectangle 1

starting fill colour = 255,255,255 (white)

I have a cell on the other part of sheet which has a value of 0 - but changes to 1 when I hover over another part of the sheet.

I need this shape to change fill from white to an image whenever that cell changes value to "1".

I need all this without clicking on an object! JUST when the cell changes, I can mange it with a click but that's besides the point.


is this possible?????

[Muzza86]

please see below for sheet

[Andy Pope]

Why not call a macro to format rectangle in the rollover macro?

Given the number of times the rollover routine is called you will probably need to check whether the shape needs updating from previous call.

[Andy Pope]

This does different colours.

Please Login or Register  to view this content.

[Muzza86]

when guys like you post it makes me realise how little I know. never used mrowlasttime before. don't really understand that. but ill have a try with it? thanks.

[Andy Pope]

mRowlasttime is just a variable containing the row value last time the rollover routine was executed. If the value is the same then there is no need to update the colour of the shape.

[Muzza86]

ok. thanks, ill try and update your code to incorporate .userpicture " " to see if shape changes image when I rollover.

[Muzza86]

I tried that code and changed the shape name, and I have 17 rollover public functions so changed it to rollover16 etc. and it still does nothing

I put it in sheet1 code. not a module?

also my shape is STARTING with an image, does that matter. but whatever I do it isn't changing the shape fill at all

[Fotis1991]

Put the code in a module.

[Muzza86]

tried. still didn't work.

[Fotis1991]

No. Works fine.

[Muzza86]

ahhhh I have to be honest, I forgot I added that example sheet. I was trying to else where/. thanks mate

[Fotis1991]

It's nice that you are honest with that but pls be more carefull when you say just"This does not works". People make efford and spent their time for helping you.

Good luck.

[Muzza86]

ah I see it may have come across a bit blunt and rude, apologies. wasn't intended. just very busy .

it works perfectly thanks, one thing - im trying to change it so that instead of a colour, it changes from one image to another now..

I tried simply replacing the .fillcolor etc with .userpicture. but I cant seem to get it to work.

is this possible?

[Fotis1991]

You have another thread about this.

[Andy Pope]

Please Login or Register  to view this content.

Change picture name and location to suit