+ Reply to Thread
Results 1 to 4 of 4

Checking/Unchecking Checkbox won't run macro

  1. 06-23-2018, 02:01 AM #1
    jennis7242
    jennis7242 is offline
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Lansing, Michigan
    MS-Off Ver
    2016
    Posts
    140

    Checking/Unchecking Checkbox won't run macro

    I have a checkbox that if checked, I want it to hide a range of rows and if unchecked, those same rows unhide. The macro isnt giving me any errors either so I don't know where the problem is as it doesn't hide/unhide anything.

    In this case, I have assigned the checkbox to cell F51 and I'm using a form control checkbox. 

    Please Login or Register  to view this content.
    Last edited by jennis7242; 06-23-2018 at 02:14 AM.
    Reply With QuoteRegister To Reply
  2. 06-23-2018, 02:10 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Checking/Unchecking Checkbox won't run macro

    Try inserting an ActiveX CheckBox instead and place the following code on Sheet Module

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 06-23-2018, 02:23 AM #3
    jennis7242
    jennis7242 is offline
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Lansing, Michigan
    MS-Off Ver
    2016
    Posts
    140

    Re: Checking/Unchecking Checkbox won't run macro

    Cool, that works. Thanks!
    Reply With QuoteRegister To Reply
  4. 06-23-2018, 02:31 AM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Checking/Unchecking Checkbox won't run macro

    You'r welcome Jennis!
    Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking and Unchecking multiple check boxes at once
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2014, 07:25 PM
  2. [SOLVED] Making cell a checkbox is linked to become active when checking or unchecking
    By dwf357 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2013, 06:49 PM
  3. Unchecking a checkbox in separate worksheet using VBA
    By halt4814 in forum Excel General
    Replies: 4
    Last Post: 01-04-2013, 10:11 AM
  4. Checkbox code incorrectly unchecking all boxes
    By ashmott in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2011, 03:44 AM
  5. Create new worksheet by ticking checkbox and then delete worksheet by unchecking box
    By barefaced66 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-19-2011, 09:45 AM
  6. Macro for unchecking checkboxes
    By Steve Strackbein in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2010, 11:46 AM
  7. [SOLVED] PivotTable - Unchecking and re-checking data fields
    By Jeff K in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1