• Macro Run (2002 SP-2)

    Author
    Topic
    #400723

    Been a year or more since I played with VBA and I have forgotten (or never knew) how to run a macro based on a value changing in a cell. Issue: If the value changes in either the cell named “FujitsuCount” or the one named “TabletCount” I need a macro to run. I have already written and tested the macro, just need to automate how/when it executes.

    TIA,
    Bill

    Viewing 1 reply thread
    Author
    Replies
    • #783632

      See Steve’s post 320604 for an example of using the WorkSheet_Change Event.

      • #784029

        Took me a bit to figure out where this code should actually reside so that it would execute – but seems to be working great. Thanks!

      • #784030

        Took me a bit to figure out where this code should actually reside so that it would execute – but seems to be working great. Thanks!

    • #783633

      See Steve’s post 320604 for an example of using the WorkSheet_Change Event.

    Viewing 1 reply thread
    Reply To: Macro Run (2002 SP-2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: