LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Tickbox value

Hi Guys,

I've a feeling this is a fairly basic question, but any help would be
appreciated...

I have a spreadsheet / questionnaire with a number of questions, and
each question has five potential answers. I've allowed the user to tick
a checkbox to indicate their answer, and linked each checkbox with a
result spreadsheet elsewhere so I can keep track of who's answered
what...

My question is this - each of the checkkboxes gives a TRUE / FALSE
value in the box that it is linked to... is there any way of changing
this value? I'd like to have a number associated with each of the
tickboxes - for example, the first box might print "0" or "1", the
second might print "0" or "2" etc...

I know I can use (if,,) to make a new table from the checkbox linked
cells but this seems a little inefficient...

Any help would be greatly appreciated...

Thanks in advance,

Chris...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i insert a tickbox in an Excel cell? mark fitzgibbon Excel Discussion (Misc queries) 1 June 23rd 09 01:27 PM
How do I count a tickbox in a spreadsheet? Rossy_t42 Excel Discussion (Misc queries) 1 August 12th 08 02:12 PM
Formula for tickbox?!? Mario London Excel Programming 2 October 27th 04 04:40 AM


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

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

About Us

"It's about Microsoft Excel"