Results 1 to 6 of 6

Multiple Worksheet Change events??? "macro" needed to hide/unhide rows multiple instances

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Multiple Worksheet Change events??? "macro" needed to hide/unhide rows multiple instances

    Is it possible to program multiple Worksheet Change Events into the same workbook? I have a lengthy set of tasks, each with 2-4 Options. I need to use list boxes (preferably) to select Options used to complete Tasks. Selecting a unique Option for each Task will hide and unhide corresponding bundles of rows in the next sheet titled "Tasks". Please take a look at the attached example. Aks2014 kindly provided me the Worksheet Change code that works for the list box in cell J18. However, I need to do this same function for about 50 tasks, some with differing number of Options, but many with the same number of Options (although each Option and its bundles of rows would be unique to the individual Tasks they reference.) How would I program it so that Sheet1 cell J20 would likewise hide or unhide its corresponding rows in the "Tasks" sheet?

    Note: to expedite your effort I've added the equivalent (partial) coding for this J20 list box in cell A133 in the "Tasks" sheet. Also note that I am ok to use individual macros for each Task and/or Option if that is easier than Worksheet Change Events.

    Thanks for your help. I am so close to getting this figured out but I need more technical expertise....

    (signed)
    The Needy Neophyte
    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. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  2. [SOLVED] Click "-" or "+" to hide and unhide rows
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2013, 08:03 AM
  3. Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  4. Hide rows based on value "0" in multiple columns
    By willieh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2012, 06:05 AM
  5. Replies: 2
    Last Post: 03-20-2012, 09:25 AM

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