VB code to change the font to white for selected range

Hello:

Please refer to attached file.

i have data range in cell A2 to B14.
I also have check box in cell C2 to C14.

I need a VB code to change the font to white for the range in column A AND B if they have corresponding check box
marked in column C.

For example :

If the box in cell C2 and C4 is marked then the corresponding range in column A and B.

Let me know if you have any questions.
Thanks.


Riz

Hello Xlbiznes:

I am getting error at If Shape(x).

Please have a look at the attached sheet, update the code and if possible please resend.
Thanks
Riz

Hi Marvin:

I have tried the code but erroring out the last "Range(Range("b" & x)).Font.Color = vbBlack
"

Please Login or Register  to view this content.

Please refer to attached file.
Let me know if you have any questions.
Thanks.
Riz

as an option

Please Login or Register  to view this content.

Hi Nilem:

Thanks a lot but looks like the code is changing the data in Column A and B and making the font white.
I would like to use the range shown in column A and B.
Basically if the i have checked boxes in cell c2 and c3 then change the font to white for Data range shown in cell A2, B2,A3 and B3.
I hope this is clear.
Please let me know if you have any questions.
Thanks.

Riz

a-ah, now it seems understood

Please Login or Register  to view this content.

Hi Nilem:

Excellent work..work great.
Can i ask you a favor to help add 1 more check box which will uncheck and check all buttons.
Thanks a lot for your great time and effort.
Riz

Hi Riz
try

Please Login or Register  to view this content.

Hi Nilem:

Below is the code i am using to accomodate my data but it is giving error.
Please let me know what changes would i need to make to make it work.
Thanks

Please Login or Register  to view this content.

Thanks
Riz

Hi Nilem:

Sorry, I got it working.
Once again thank u so much for all the help.
Riz