Thanks for your posts. I am familiar with VBA but not very familiar with the form controls. I wanted to have two checkboxes that were related in that when the user clicked on one then the actions performed would differ if the other checkbox was selected or not.

I had originally thought on the click event of one checkbox, I could navigate to the initially selected checkboxes' linked cell, offset to the cell containing the related checkbox and then check it's selected state to determine what actions to perform.

However, I have since found the name property of the checkbox control and am naming all of the controls with names that are related and easily identifiable. Therefore, when a chcekbox is clicked I can deduce the name of the control I need to check by parsing the name of the selected checkbox and doing some string manipulation followed by a direct reference to the now identifiable and related checkbox.

It works a treat.