Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JEB JEB is offline
external usenet poster
 
Posts: 40
Default Linking more then one cell to a Check Box

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Check Boxes Nightshade Excel Discussion (Misc queries) 3 March 12th 08 05:00 PM
Cannot check the check mark box in cell ac Excel Worksheet Functions 1 February 15th 08 10:24 PM
Check box formulaes and linking. Kev Excel Discussion (Misc queries) 0 January 23rd 08 12:11 AM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
Linking check boxes so if one is true the other shows false Carl Excel Discussion (Misc queries) 4 September 8th 06 03:18 AM


All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"