I am trying to create a spreadsheet with two worksheets, the first is a list
where the user checks off a series of check boxes in a list, the second
worksheet is intended to be formula driven using the check boxes to calculate
the value of each item in the list. Hence I want to use the IF command in the
second worksheet to say if check box is clicked then the value equals x.

I am having problems linking the visual basic check box to the excel sheet.

Any suggestions?