Posted By

derekholmes on 12/28/09

Tagged

excel

Versions (?)

Last Edited at 12/28/09 01:02pm

Statistics

Viewed 992 times

Favorited by 0 user(s)

Related snippets

Excel: Run Macro on Cell Change

/ Published in: Visual Basic

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

Copy this code and paste it in your HTML

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

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

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.