Prev: auto copy and paste to another workbook by using specific titles
Next: Macro to save a workbook
From: Sucram on 28 Apr 2010 10:12
I'm setting up a series questions that are answered yes/no by ticking a
checkbox.

Is it possible to assign a different value to each checkbox so I can produce
a 'final' value based on the boxes checked?

(I'm trying to 'wieght' the answers given, in order to assign a final 'score')

Many thanks in adavnce of any reply!
From: Gary Brown on 28 Apr 2010 11:51
Link your checkboxes to cells (for example 3 checkboxes linked to A1, A2 and
A3 respectively).
In A4, create a formula to weigh the values.
example: =(a1*.4)+(a2*.5)+(a3*.1)
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Sucram" wrote:

> I'm setting up a series questions that are answered yes/no by ticking a
> checkbox.
>
> Is it possible to assign a different value to each checkbox so I can produce
> a 'final' value based on the boxes checked?
>
> (I'm trying to 'wieght' the answers given, in order to assign a final 'score')
>
> Many thanks in adavnce of any reply!
From: Helmut Meukel on 28 Apr 2010 13:17
"Sucram" <Sucram(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:418B4C2D-8001-4C02-9A8C-EA14D860524C(a)microsoft.com...
> I'm setting up a series questions that are answered yes/no by ticking a
> checkbox.
>
> Is it possible to assign a different value to each checkbox so I can produce
> a 'final' value based on the boxes checked?
>
> (I'm trying to 'wieght' the answers given, in order to assign a final 'score')
>
> Many thanks in adavnce of any reply!



Using the Tag property of the checkbox would be a solution.

HTH.

Helmut.

 | 
Pages: 1
Prev: auto copy and paste to another workbook by using specific titles
Next: Macro to save a workbook