advanced code snippet search

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'.

Expand | Embed | Plain Text 
  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.