September 6th, 2008, 06:41 PM
|
Experienced Member
|
|
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
|
|
Dave,
Thanks it works, simple really.
Shirl
Quote:
Originally Posted by Dave Peterson
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
|
|