Checkboxes in Excel 2007

S

shirl

I am using Excel 2007 and want to create a survey form for staff using
checkboxes (form controls) and I want to use a countif to count the
number of cells which contain a ticked checkbox. eg
COUNTIF(C4:C8,TRUE). The results of the countif will determine if they
need IT training.

I have worked out how to remove the text which says checkbox1 (next to
the checkbox) but I cannot remove the text behind the textbox which
says either true or false.

Any suggestions on what I am doing wrong?

Also does anyone have any idea how I can use one spreadsheet which
numerous staff can complete - the spreadsheet is going to ask them
questions about their IT skills and I want to capture each individuals
details and responses - I suspect that the only way to do this is use a
database, however I want to produce something that looks similar to a
Word document so as not to put off users with little or no IT skills.

I do not have VB skills.


Thanks
Shirl
 
S

shirl

Dave,

Thanks it works, simple really.

Shirl
Give the cell a custom format of:
;;;
(3 semicolons)

If you decide you want to use optionbuttons instead of checkboxes, yo
may want
to look at Debra Dalgleish's site:
http://contextures.com/xlForm01.html

shirl wrote:-

I am using Excel 2007 and want to create a survey form for staf
using
checkboxes (form controls) and I want to use a countif to count the
number of cells which contain a ticked checkbox. eg
COUNTIF(C4:C8,TRUE). The results of the countif will determine i
they
need IT training.

I have worked out how to remove the text which says checkbox1 (nex
to
the checkbox) but I cannot remove the text behind the textbox which
says either true or false.

Any suggestions on what I am doing wrong?

Also does anyone have any idea how I can use one spreadsheet which
numerous staff can complete - the spreadsheet is going to ask them
questions about their IT skills and I want to capture eac
individuals
details and responses - I suspect that the only way to do this is us
a
database, however I want to produce something that looks similar to a
Word document so as not to put off users with little or no IT skills.

I do not have VB skills.

Thanks
Shirl
Click to expand...
 
Top