+ Reply to Thread
Results 1 to 5 of 5

Double Click different cells, with toggle of check marks on and off & run specific macros

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Saskatoon, SK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Double Click different cells, with toggle of check marks on and off & run specific macros

    I've been googling for 3 hours and can't find the right answer.
    What I want the VBA code to do is if I click on cell A2, a check mark will appear and then a specific macro will run to show a range of rows. And, if I click on cell A2 again, the check mark will disappear and then a specific macro will run to hide that same range of rows. Furthermore, if I click on cell A3, a check mark will appear and then another specific macro will run to show a different range of rows. And, if I click on cell A3 again, the check mark will disappear and then that specific macro will run to hide that same range of rows and so on and so forth for cells C4, C5, C6, E7, E8, E9, H10, H11, etc. and their corresponding ranges of rows.
    Please help quickly, my boss wants this in about 3 hours!

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-15-2012
    Location
    Saskatoon, SK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Double Click different cells, with toggle of check marks on and off & run specific mac

    Anyone out there to help?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,913

    Re: Double Click different cells, with toggle of check marks on and off & run specific mac

    Which range of cells is associated with the clicks for A2? A3? I'm not understanding. There seems to be a gap here in what has to take place. If you were to do this manually, what would the actions be. Try to be as specific as possible.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    05-15-2012
    Location
    Saskatoon, SK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Double Click different cells, with toggle of check marks on and off & run specific mac

    If I would click A2, a check mark would appear and then rows 4-12 would unhide. If I would click A2 again, the check mark would disappear and then rows 4-12 would hide.
    If I would click A3, a check mark would appear and then other rows would unhide. If I would click A3 again, the check mark would disappear and then those other rows would hide.
    And so on and so forth.

  5. #5
    Registered User
    Join Date
    05-15-2012
    Location
    Saskatoon, SK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Double Click different cells, with toggle of check marks on and off & run specific mac

    I previously had it working great with ActiveX checkboxes but then I opened my file up the next day and went to try it again only to find that when I unhide some rows all the checkboxes in column A were piled up on top of each other on the row below the last one that was unhidden. I couldn't have that happen every time a user went to use the file.

+ 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. Toggle BackColor of labels in Userform through "click" and "double-click"
    By ahmerjaved in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:08 PM
  2. [SOLVED] Check Box click to display a specific value.
    By Zaid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2013, 09:41 AM
  3. [SOLVED] Run macro on double click - several macros on one worksheet
    By Hobbage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 09:49 AM
  4. VBA toggle between colours on double click
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2013, 10:27 AM
  5. [SOLVED] check marks in excel cells using your mouse
    By loco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2006, 05:35 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