VBA Checkbox with 2 cells for reference

23 viewsexcelvba
0

I have 4 different checkboxes with the same text "OTHER" but in different sections: Really Low, Low, Middle and High. I need the checkbox in the correct section to be checked if its reference cell has the value "Other" and the second reference cell has the value of its section (Really Low, Low, Middle and High).

Currently, I have the following VBA for just one cell reference that works correctly but now need to add another reference value.

Sheets("Sheet1").CheckBox48.Value = Sheets("Sheet2").Cells(i, "ah") = "Other"