Results 1 to 2 of 2

Call Macro on Cell Change

Threaded View

erock24 Call Macro on Cell Change 11-12-2009, 03:35 PM
erock24 Re: Call Macro on Cell Change 11-12-2009, 04:59 PM
  1. #1
    Forum Contributor
    Join Date
    02-20-2007
    MS-Off Ver
    2003 & 2007
    Posts
    299

    Call Macro on Cell Change

    I am trying to create a worksheet change event that calls a macro (private sub stored in same worksheet module as change event).

    I need the change event to call the macro when either range("FinalDrop") or range("UpdNmDrop") change values. Both these cells are data validation lists.

    I've been messing with this but can't get it to work:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Target.Address = "FinalDrop" Then
        Call AdjustCoopPivots
    End If
    If Target.Address = "UpdNmDrop" Then
        Call AdjustCoopPivots
    End If
    Application.EnableEvents = True
    End Sub
    Last edited by erock24; 11-12-2009 at 04:59 PM.

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