If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Checkboxes in Excel 2007
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 |
#2
|
|||
|
|||
Checkboxes in Excel 2007
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 |
#3
|
|||
|
|||
Dave,
Thanks it works, simple really. Shirl Quote:
|
Thread Tools | |
Display Modes | |
|
|