I would like to run my script automatic when a value from one off my
collums changes. Can anyone help me out, cause im kinda stuck here.

Thanks in advance,

Joost Knol


---
Message posted from http://www.ExcelForum.com/

Hi Joost,

I would like to run my script automatic when a value from one off my
collums changes. Can anyone help me out, cause im kinda stuck here.


Check out the Worksheet_Change event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("A1:B10")) Is Nothing Then Exit Sub
MsgBox "Your code"
End Sub

Rightclick a sheet tab, choose View code and paste and modify the code
above.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Thanks it worked :D


---
Message posted from http://www.ExcelForum.com/