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

If you decide you want to use optionbuttons instead of checkboxes, you 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 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

--
shirl

--

Dave Peterson

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




--
shirl

Dave,

Thanks it works, simple really.

Shirl

Dave Peterson;2953401 Wrote:
Give the cell a custom format of:
;;;
(3 semicolons)

If you decide you want to use optionbuttons instead of checkboxes, you
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 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

--
shirl-

--

Dave Peterson




--
shirl