VBA in Excel 2007

Hi Craig

Thank you for your question

You first need to add a check box to your form and give it a meaningful name.

I then suggest that you create an on click event for the check box, and within this declare a variable of boolean type.Then, using an IF statement, set the value of the boolean variable to true if the value of the combo box is true, and false if it is false

You can then use this variable as a test to see if a particular action is carried out

Hope this is useful

Regards

Stephen