How do Programattically Insert an Worksheet_Change Event????

[rflyr98]

I am creating a new sheet programatically, and would like to add this event to the new "Activesheet" programatically.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 5 And Target.Column = 4 Then
ActiveCell.Offset(-1, 2).Activate

End Sub

I have looked and looked and I just cant find anything.
Many Thanks in Advance...
Rob

 

[pgc01]

Hi Rob
Welcome to the board

If you want to edit code with a macro you have to use the codemodule object.

Read carefully the first part of this page and adapt "Adding A Procedure To A Module"

http://www.cpearson.com/excel/vbe.htm

Hope this helps
PGC

 

[Dufus]

rflyr98,

You can copy a sheet that has the event already attached to it if you want to keep it simple.

Dufus

 

[rflyr98]

Dufus that has worked great, thanks