View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Linking more then one cell to a Check Box

The linked cell will be either TRUE or FALSE based on the state of the
checkbox. Link any cell to the checkbox, then refer to that cell from as many
other cells as you want. For example, if A1 was linked to the checkbox, other
cells could refer to A1:

=IF($A$1,B1*10,C1/10)

Hope this helps,

Hutch

"Jeb" wrote:

I would like to link more then one cell to a check box. Each cell would do a
different function but I would like it to happen at the same time when I
check the box. Is this possible to do? If not how could I make that happen
then?

Thanks