Results 1 to 5 of 5

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

Threaded View

  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

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