Launching a macro by changing a cell

[daniroy]

Hello there,

I need to Launch Sub XYZ() when changing cell "C8" in Sheet123.

How am I suppose to do that ?

thanks everybody!

 

[Dr. Stephan Kassanke]

Hello there,

I need to Launch Sub XYZ() when changing cell "C8" in Sheet123.

How am I suppose to do that ?

thanks everybody!

Copy the following Macro to the code sheet of worksheet "Sheet123"

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$8" Then
Call XYZ
End If
End Sub

cheers,
Stephan

 

[daniroy]

thanks Stephan it is working just fine !
Best Regards,
Daniel

 

[Dr. Stephan Kassanke]

thanks Stephan it is working just fine !
Best Regards,
Daniel

Daniel,

you are welcome, glad I could help.

Stephan