Visual basic Check Box and the IF formula

[dingo33]

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?

[Bob Phillips]

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
Properties>Control an define the cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"dingo33" <[email protected]> wrote in message
news:[email protected]...
> 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?

[dingo33]

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?

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?