+ Reply to Thread
Results 1 to 4 of 4

Copy tick from checkbox to another checkbox

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    2

    Red face Copy tick from checkbox to another checkbox

    Hi,

    How do I copy ticks from check boxes. That is if I check one tick box this is copied accoss to another check box on another worksheet.

    Same with unchecking the box?

    Thanks

    Angie

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Which type of tickbox are you using (Forms Tickbox or Contorl Toolbox Tickbox)
    & where have you placed them
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    12-18-2007
    Posts
    2

    Tickbox help

    Hi,

    The tick box was from the Forms toolbox and I have placed them directly on worksheets in excel.!!!

    Thanks

    Angie

  4. #4
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    You can link multiple checkboxes to the same cell

    Example
    To link a Check box on Sheet2 to a A1 in Sheet1
    Set the Cell Link property to be
    Sheet1!$A$1

    For The Checkbox on Sheet1 set the Cell Link property to A1

+ 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