+ Reply to Thread
Results 1 to 4 of 4

Running a macro each time certain cell content is changed

  1. #1
    Registered User
    Join Date
    04-29-2007
    Location
    Lisbon, Portugal
    Posts
    58

    Question Running a macro each time certain cell content is changed

    Dear All,

    I'm trying to find a way of running a macro each time certain cell content is changed. The advantage of this is not having to create a button or a shortcut to run the macro.

    If you could help me on this one I’d be grateful

    Thanks
    Manuel

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    This macro when installed correctly will call another macro when the value in A1 is changed

    Change range and called macro as required

    'These instructions pre typed & are worded to cater for the novice programmer
    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Select sheet this is to appy to
    'Right Click on Sheet Name Tab > select View Code
    'Past macro into the Worksheet Module displayed




    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    04-29-2007
    Location
    Lisbon, Portugal
    Posts
    58
    Thanks. I'll use this code and then I'll give you some feedback

    Regards

  4. #4
    Registered User
    Join Date
    04-29-2007
    Location
    Lisbon, Portugal
    Posts
    58
    Excellent!
    Macro is already working.

    Thanks once again mudraker

    Regards

    Manuel

+ 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