+ Reply to Thread
Results 1 to 3 of 3

How to copy check boxes without having to always change the control cell link

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Utah
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    How to copy check boxes without having to always change the control cell link

    I have a spreadsheet that uses several check boxes to track which documents are available in an online library. Every time I add new documents to the spreadsheet, I drag the last cell (containing the check box) down over the new cells. When I copy the check boxes this way, the cell link remains the same for all check boxes I copy. I then have to fix each of the new check box's "cell links" by right clicking on the object and selecting format control. If I add a couple new documents at a time, It's no big deal to format each of the new check boxes one at a time. However, If I need to add several new docs (50+) and it's a pain to have to right click on every new check box to change the "cell link" field. Is there a way to copy a check box down several columns and have Excel auto calculate/update the cell link?

    For Example: If I have a check box in cell A1 with a cell link of $B$1 and I want to copy this cell down 50 columns (to add 50 new check boxes)... I want the "cell link" to change accordingly, $B$2, $B$3, $B$4, $B$5, etc.

    Any help is appreciated!

    Thanks,
    jnlong

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,508

    Re: How to copy check boxes without having to always change the control cell link

    Check out this example. Enable macros for it to work.
    Attached Files Attached Files

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to copy check boxes without having to always change the control cell link

    You might be able to do that by using VBA but simply copying and pasting won't do what you want because the check boxes are objects "floating" over the cells and are not contents of a cell. Cell references for the check boxes are simply copied as well as the check boxes themselves.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1