+ Reply to Thread
Results 1 to 3 of 3

Checkboxes

  1. #1
    Registered User
    Join Date
    05-13-2021
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Question Checkboxes

    Hello everyone,
    When I put my checkboxes into the spots I want them, when I click one of them, another one checks as well. How do I stop that? Is there a faster way to get check boxes into my cells instead of copying and pasting an existing one?
    Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Checkboxes

    Hi,

    Are we talking about Forms checkboxes or Activex checkboxes?

    It sounds like you have linked the first checkbox to a cell which is replicated every time you copy and paste the control.
    The only way to do this automatically is with a macro.e.g.
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-13-2021
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Re: Checkboxes

    Hello,
    I am unsure. I was given a spreadsheet that my company used before and I am trying to make some improvements. There is a pop-up that pops up sometimes that says "macros has been disabled". Where would I put the command? I am unsure what kind of checkboxes they are. Is there a way to easily place a basic checkbox in a cell?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. hiding rows which contain checkboxes but checkboxes don't hide as they should
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-08-2019, 10:26 AM
  2. Using Checkboxes to control other sets of checkboxes
    By Entregan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2018, 01:59 PM
  3. [SOLVED] Checkboxes - How to check/uncheck other checkboxes based on another checkbox
    By brooklyn_87 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-27-2017, 01:20 PM
  4. [SOLVED] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  5. master checkboxes to select a group of other checkboxes?
    By fael097 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-26-2016, 03:46 PM
  6. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM

Tags for this Thread

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