Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i insert a tickbox in an Excel cell? | Excel Discussion (Misc queries) | |||
How do I count a tickbox in a spreadsheet? | Excel Discussion (Misc queries) | |||
Formula for tickbox?!? | Excel Programming |