+ Reply to Thread
Results 1 to 3 of 3

Automatically Trigger Event when Cell Changes

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Automatically Trigger Event when Cell Changes

    Hi, I'm trying to create a drop-down menu of sorts that is available in every page of the worksheet. I have the value of every page's drop down box linked to a hidden spreadsheet that uses a vlookup table to give a value based off of what "menu option" is chosen with the "default" option yielding a value of 0. I have the sum of all of the pages' numerical values in a cell on this spreadsheet and would like to create a macro that triggers whenever this cell (containing the sum) is not equal to 0. The cell that is going to be triggering the macro when not equal to 0 will be on the hidden page (MACRS Loans) and therefore not active. The Run Reset_menu at the bottom of the code runs a macro that changes all of the drop down boxes back to their default value after the page is changed in order to reset the macro. Below is what I have so far in VB, the macro works when manually executed but not automatically when the cell is changed. Any help would be much appreciated, Thanks!

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 06-01-2013 at 08:25 AM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Automatically Trigger Event when Cell Changes

    Please Login or Register  to view this content.
    The above code has to be in the relevant worksheet module
    Note that the macro won't trigger unless the enter key is pressed
    Elegant Simplicity............. Not Always

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,098

    Re: Automatically Trigger Event when Cell Changes

    Hi, Thinkslow,

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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