How to do checklist to highlights and uncheck to undo highlights for values in excel vba

[fahadun]

hello,
I am very new to vba programming. I am facing a new problem.
What i am trying to do here,Create 6 check boxes that will highlight 6 different values after comparing two columns. so I can undo the highlights when i uncheck them.

So i have two sheet, sheet1 and sheet2. I wanna create First 3 checkbox after comparing between sheet1 column "C" and sheet2 column "R".

• First checkbox will highlight green,those mc# in sheet1 column "C", that are common in sheet1 and also in sheet2
• second checkbox will highlight yellow, those mc# in sheet1 column "C", that mc# is in sheet1 but not in sheet2
• third checkbox will highlight red, those mc# in sheet2 column "R", that mc# is not in sheet1 but is in sheet2

last 3 check boxes will compare between sheet1 column "B" and sheet2 column "O".

• fourth checkbox will highlight green,those wr# in sheet1 column "B", that are common in sheet1 and also in sheet2
• fifth checkbox will highlight yellow, those wr# in sheet1 column "B", that wr# is in sheet1 but not in sheet2
• sixxth checkbox will highlight red, those wr# in sheet2 column "O", that wr# is not in sheet1 but is in sheet2

Thank you very much in advance. here is the sample pictures