Combo box questions

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I sum up several check boxes conditioned by a combo box? 4
Graph linked with combo boxes 2
tab over in form 2
Combo box result text not number 2
List box or Combo box?? 1
Access MS Access Listbox not saving to bound field 0
hide combo box 6
Combo box VBA error 5

Top