Results 1 to 5 of 5

Run Macro On Cell Change

Threaded View

  1. #1
    Registered User
    Join Date
    02-14-2019
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5

    Run Macro On Cell Change

    I currently have the below macro set up so that i enter a cell in V2 and click a button and it jumps to that cell. How do I modify it so that it activates whenever cell V2 changes, rather than having to click the button?

    Private Sub JumpTo_Click()
    Dim C, R As Range, Cell As Range
    Set R = Range("C1:C4000")
    C = ""
    For Each Cell In R
        If Cell.Value = ActiveSheet.Range("V2") Then
           C = Cell.Address
        End If
    Next
    If C = "" Then
       MsgBox "NOT FOUND " & ActiveSheet.Name
       Exit Sub
    Else
       Range(C).Offset(0, 0).Select
    End If
    End Sub
    Attached Files Attached Files
    Last edited by Livewire089; 02-19-2019 at 08:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change On_Open macro to a cell change in a range of cells
    By davidpierce in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2015, 02:46 PM
  2. Macro code to call a macro if a certain cell's value is change
    By mm671750 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 12:37 PM
  3. Cell change --> date change macro
    By K3mp3r in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2014, 05:31 AM
  4. [SOLVED] Macro - To change cell fonts whenever their values change
    By mgs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2012, 03:14 AM
  5. [SOLVED] Worksheet change macro on a change in a specific cell
    By dzuspann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 04:19 PM
  6. Replies: 11
    Last Post: 08-31-2010, 01:30 PM
  7. [SOLVED] Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM

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