+ Reply to Thread
Results 1 to 2 of 2

Select All Checkboxes Checkbox That Also Calls Checkbox Macros

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    PA, USA
    MS-Off Ver
    2007
    Posts
    2

    Select All Checkboxes Checkbox That Also Calls Checkbox Macros

    Hi all,

    I've set up a large number of checkboxes and coded a "master checkbox" to select them or unselect them all. Each individual checkbox is assigned a macro that will hide a certain number of rows on another sheet. This macro works fine when I individually click on each checkbox, but the macro will not run when selected via the master checkbox. I'd appreciate any insight you could offer.

    Here is my code so far:
    For the select all checkbox:
    Please Login or Register  to view this content.
    The Hiderows Macro - This is set to hide a certain number of rows on a sheet based on the checkbox output cell in another sheet.
    Please Login or Register  to view this content.
    Individual Checkbox Macro - calls HideRows and assigns interaction with Select All Checkbox (allows selection/deselection of individual checkboxes while master is checked)
    Please Login or Register  to view this content.
    Namely, I want to be able to click the master checkbox and execute the HideRows macro across all checkboxes, and vice versa. Any help greatly appreciated.

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    204

    Re: Select All Checkboxes Checkbox That Also Calls Checkbox Macros

    you may want to try
    Please Login or Register  to view this content.
    instead of
    Please Login or Register  to view this content.

+ 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. Checkboxes VBA: name of checkbox to appear in a certain cell
    By Jungfuchs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 05:29 AM
  2. Making One Checkbox Check Other Checkboxes plus more
    By zapatam21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-19-2013, 02:19 PM
  3. One checkbox that selects multiple checkboxes
    By pozmoney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2013, 05:57 PM
  4. Multiple checkboxes to tick 1 checkbox
    By tUyET dEn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2009, 04:07 AM
  5. Checkbox locking out other Checkboxes
    By Rich Kniatt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2005, 05:34 PM

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