Combo box questions

C

ckane

I have created a worksheet using combo boxes and check boxes. Is there a way
to sort the information that was selected in the combo boxes? Also, is there
a way a formula to use for the check boxes, for instance if a box is checked
= 1. The formula would add all of the checked boxes for each column. Thank
you.
 
O

OssieMac

If you link a cell to the check box in properties then that cell will show
True or False. You could then put a formula in another cell =if(CellRef =
true,1,0) and then sum the results in another cell.

Can't answer your other question.

Regards,

OssieMac
 
Top