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?

You need to link the checkbox to a cell, and test that cell value.

Linking a forms checkbox is done by simply right-clicking it, select
PropertiesControl an define the cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"dingo33" wrote in message
...
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?

Thanks Bob, Took some tinkering but wokred it out,

Thanks again

"dingo33" wrote:

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?

That's the best way, you will have learnt more from that than by me just
spelling it out.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"dingo33" wrote in message
...
Thanks Bob, Took some tinkering but wokred it out,

Thanks again

"dingo33" wrote:

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?