Thread: Attach code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default Attach code

Right-click on the sheet name at the bottom
Choose View Code to open VB Editor
Click on the first dropdown and choose Worksheet
You can see all related events in the second dropdown...
Choose Change

You will see
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Enter the code between Sub/End Sub.

"MAX" wrote:

How to attach the code to a Sheet_Change event