Hi folks, long time lurker here using Excel 2010...

I have a drop-down list in cell H8 that contains 4 values (A thru D). Their TRUE/FALSE results are stored in unlocked cells on another protected sheet in the workbook.

If A or B are selected, I'd like for Check Box 96 and 97 (on the original page) to check automatically, but still be de-selectable if required.

If C or D are selected, I'd like for 96 and 97 to uncheck automatically, but still be selectable if required.

I've toyed around with VB code but TBH I don't know what I'm doing. Admission is the first step, right? haha

Many thanks,
Craig