+ Reply to Thread
Results 1 to 4 of 4

Worksheet_SelectionChange Event to Run Public Sub MyMacro

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Worksheet_SelectionChange Event to Run Public Sub MyMacro

    Hello,

    My worksheet has a validation list in cell E9. Whenever a user changes the selection (A, B or C) from the drop-down list, two Public macros must run: Update_GPMPct(), and Filter_Details (). This is what I have so far....

    Please Login or Register  to view this content.
    I would be most grateful for your suggestions to make this run.

    Thanks!
    Karla
    Last edited by KarlaM; 10-09-2013 at 04:23 PM.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Worksheet_Change Event to Run Public Sub MyMacro

    If you want to respond to changes in your worksheet's cells you should use Worksheet_Change iso Workstation_SelectionChange. The latter fires when another cell is selected.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    09-10-2013
    Location
    Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Worksheet_Change Event to Run Public Sub MyMacro

    Thank you for your response! My code is actually the Worksheet_SelectionChange event you suggested. I have changed the title of my post to properly reflect that.
    Thanks!
    Karla

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Worksheet_SelectionChange Event to Run Public Sub MyMacro

    May be I don't understand your problem (sorry if that's the case), but the code snippet you posted shows:
    Please Login or Register  to view this content.
    My suggestion was to change that to:
    Please Login or Register  to view this content.

+ 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. [SOLVED] Run Public Sub in Worksheet_Change Event
    By vba_beginner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2013, 01:07 PM
  2. Worksheet_Change event
    By serge.pigeot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2012, 03:20 AM
  3. Worksheet_Change Event won't run more than once
    By David McMillon in forum Excel General
    Replies: 2
    Last Post: 07-08-2010, 04:02 PM
  4. Public variable not recognized in event
    By kblum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 05:25 PM
  5. [SOLVED] Worksheet_Change Event
    By safflenow in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 01: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1