refering to a checkbox

  • Thread starter Thread starter lsu-i-like
  • Start date Start date
L

lsu-i-like

if i have two checkboxes, one for job 1 and one for job 2, how do
refer to which checkbox is checked? if job 1 is checked i want to ad
all the info for job 1 in box A23. if job 2 is checked i want to ad
all the info for job 2 in box A23
 
And you could have both checkboxes checked, too.

But if you use a linked cell for each checkbox, you could check to see which
were checked.

=if(x1=true,"howeveryouaddjob1","howeveryouaddjob2")

I think I'd either replace the two checkboxes with a pair of option buttons or
with a single checkbox.

If checked, use job 1. If unchecked, use job 2.

And there are two checkboxes available on the worksheet.

If from the Forms toolbar, rightclick, choose Format control|control tab.

If from the control toolbox toolbar, go into design mode, rightclick on the
checkbox and select properties. Look for LinkedCell.
 
Back
Top