Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I associate a formula with Checkboxes
Is it possible that I can associate a formula along with check boxes.
example: There are four check boxes UN, NI, AE, & EE. If UN is selected it is worth 1 point, NI worth 2pts etc.? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I associate a formula with Checkboxes
Probably, with some VBA coding. But what do the checkboxes get you that
putting the values in a cell don't? I.e., a formula like =IF(A1="UN",1,IF(A1=NI,2,...)) Dave -- Brevity is the soul of wit. "Todd Nelson" wrote: Is it possible that I can associate a formula along with check boxes. example: There are four check boxes UN, NI, AE, & EE. If UN is selected it is worth 1 point, NI worth 2pts etc.? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I associate a formula with Checkboxes
If you use linked cells for each of those checkboxes, you could refer to those
linked cells. Say you linked to A1:A4 (UN, NI, AE, EE respectively). =a1*1 + a2*2 + a3*3 + a4*4 The linked cells will be true or false. True * a number = that number. False * a number = 0 Todd Nelson wrote: Is it possible that I can associate a formula along with check boxes. example: There are four check boxes UN, NI, AE, & EE. If UN is selected it is worth 1 point, NI worth 2pts etc.? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repost: Min/Max help needed with a SumProduct | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |