LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default change cell link for many check boxes at once

I use a lot of check boxes (from the Forms toolobar) in my application.
Often they are all in a column and I want all of the linked cells to be all
in a column as well. For example, Checkbox1 (CB1) is in c1, linked to r1;
CB2 is in c2 linked to r2, CB3 is in C3 linked to R3, etc.

Is there any way to set all the cell links at once using some form of
relative referencing? I have not been able to do this. I have to set each
individual cell link reference by hand.

I am using Office 2003.

--
Thanks,
Andy
 
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
link check boxes in multiple cells Taz22i Excel Discussion (Misc queries) 1 July 17th 08 04:24 PM
Can I change default check boxes on protect sheet? DWAyers Excel Discussion (Misc queries) 1 February 4th 08 06:00 PM
link to check boxes Hmartinez Excel Discussion (Misc queries) 1 April 19th 07 05:22 PM
I need to link check boxes to 3 different cells Jose M. Excel Worksheet Functions 1 October 28th 06 04:39 AM
How do you link Check Boxes? Mike A. Excel Discussion (Misc queries) 1 May 24th 06 07:54 PM


All times are GMT +1. The time now is 09:16 AM.

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

About Us

"It's about Microsoft Excel"