+ Reply to Thread
Results 1 to 4 of 4

Worksheet Change event ignore change event

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Worksheet Change event ignore change event

    Okay, I know I've got a contradiction here; it's obvious I need help.

    The situation: Cells E1:E3 are dropdowns for the Division, Program Area, and Account. The user picks his Division, whereupon my macro determines the available Program Areas. The user picks Program, whereupon my macro determines the available Accounts. User picks the Acct, my chart populates. All of this happens through autofilters and change events. What I want to happen is if there's a change in E1 (Div), I want to clear E2:J2 and E3:I3. But I DON'T want those "clearances" to show as change events, because I want to capture the subsequent action in E2 (Prog) and E3 (Acct).

    The problem: Any change in E1 triggers a change in E2 and E3, so those macros run also I'd like to somehow run the macros only when my user makes a change, not when the automation clears the cells. In other words, I don't want Filter2 and 3 to run when I change E1, and I don't want the Filter 3 to run when I change E2. Any ideas how I can go about doing that?

    My current code is posted below. Since this involves multiple sheets I didn't provide an example. If one is required for this please let me know.

    Any help is greatly appreciated.

    Thanks,
    John

    Please Login or Register  to view this content.
    Last edited by jomili; 07-07-2011 at 12:29 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Worksheet Change event ignore change event

    If you put
    Please Login or Register  to view this content.
    the intervening code will not trigger the event.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Re: Worksheet Change event ignore change event

    Sweet! That should be an easy fix, and here I've been sweating it for hours. I'm implementing your solution as in the code below; let me know if you see anything obviously wrong. I'll let you know how it works out.
    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Re: Worksheet Change event ignore change event

    I'm back! It seems to have worked beautifully! But now I have another problem, same project, but whole different flavor. But, I'll mark this one solved, and create another post. Thanks for quick and good help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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