Question about an event

  • Thread starter Thread starter Joost
  • Start date Start date
J

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.

Thanks in advance,

Joost Knol
 
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.
Click to expand...

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
 
Back
Top