View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.?