Hi all,
I found a lot of useful tips and tricks in this forum and was wondering whether someone could help me with shape formatting via VBA.
This is an example I found in this forum however I'm struggling to find a way to fix an issue I'm having. I need for the shapes to change its transparency via another cell. It works if that particular cell value is changed manually but it doesn't if that cell has a formula that links to another cell (please see attached). Am I missing something in the code? I need the transparency to change after A1 value and A2 value is changed.
I found a lot of useful tips and tricks in this forum and was wondering whether someone could help me with shape formatting via VBA.
This is an example I found in this forum however I'm struggling to find a way to fix an issue I'm having. I need for the shapes to change its transparency via another cell. It works if that particular cell value is changed manually but it doesn't if that cell has a formula that links to another cell (please see attached). Am I missing something in the code? I need the transparency to change after A1 value and A2 value is changed.