Posted By

derekholmes on 12/28/09


Tagged

excel cell change


Versions (?)

Excel: Run Macro on Cell Change


 / Published in: Visual Basic
 

URL: http://www.excelforum.com/excel-programming/629622-run-macro-everytime-cell-content-changes.html

The easy way to set this up is to go to the macro window by pressing alt+F11. Select the sheet from left panel. there will be two drop down. from the left drop down select worksheet and from right drop down list select the event 'change'.

  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Target.Address = "$D$8" Or Target.Address = "$D$7" Or Target.Address = "$D$9" Then
  3. Call Module1.AutoGoalSeek
  4. End If
  5. End Sub

Report this snippet  

You need to login to post a comment.