Launching a macro by changing a cell

  • Thread starter Thread starter daniroy
  • Start date Start date
D

daniroy

Hello there,

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

How am I suppose to do that ?

thanks everybody!
 
Hello there,

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

How am I suppose to do that ?

thanks everybody!
Click to expand...

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