Visual basic Check Box and the IF formula

D

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?
 
B

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)
 
B

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)
 
Top