Reference Cell as range().value doesn't work

[cmdrdanno]

Here is my code. It is a simple change shape colour based on cell value. If I put a an actual value for the "Case" statements then it works just fine. Trying to make this more robust by referencing a table/cells and it doesn't update.

Please Login or Register  to view this content.

[Norie]

That should work, have you tried stepping through with F8 after setting a breakpoint, with F9, at the start of the sub.

By the way, an if statement might be more appropriate.

Please Login or Register  to view this content.