Is it possible, using VBA, to fill a shape based on a different cell value

Hi everyone,

I’m new to both this forum and using VBA (my limited experience consist of recording a few macros and making minor tweaks to them).
I’ve come across a problem that I can’t use the record button for:

I want to fill a Shape with Color based on the contents of a certain cell.

For Example:
If cell E1 =1 then fill shape "Flowchart: Process 1" with Yellow and if E1 = 0 then fill shape "Flowchart: Process 4" with Red.
And
If cell H1=1 then fill shape "Flowchart: Process 2" with Yellow and if E1 = 0 then fill shape " Flowchart: Process 3" with Red.

Is there a simple way to code this?

Thanks,
SDG2012

Hi SDG

Can you post a copy of your workbook with the Flowchart shapes in it?

Mowgli

Here's the example file.

Thanks again,

SDG,

Is this the sort of thing you are wanting?

Mowgli

Flowchart Colours.xlsm

Post this code into your "ThisWorkbook" section

Please Login or Register  to view this content.

I have assumed that you meant cell H1 to control the colour of Flowchart: Process 3 as opposed to E1 changing it to red as E1 would then make both boxes red. If I am wrong its easy changed

Mowgli

This is exactly what I needed. It worked perfectly.

thanks so much for your help!

Happy to be of help

Don't forget to mark your thread SOLVED