A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Checkboxes in Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old September 6th, 2008, 12:16 AM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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  
Old September 6th, 2008, 02:06 AM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Default 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  
Old September 6th, 2008, 06:41 PM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Smile

Dave,

Thanks it works, simple really.

Shirl

Quote:
Originally Posted by Dave Peterson View Post
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.