workbook_sheetchange

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

where do i put code using the workbook_sheetchange event ... what i'm trying
to do, is update a column on a sheet when anything on the summary sheet
changes.

thanks
JulieD
 
Try right-clicking on the Excel icon
(just to the left of "File" on the menu)

Choose "View Code"

In VBE, select "SheetChange" from the right droplist
(or just paste the code in the whitespace there
after clearing the defaults)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date does not update until worksheet change 5
Add a comment when cells are changed 2
Workbook_SheetChange event 1
Excel 95 equivalent of modern events? 6
Private Sub Workbook_SheetChange 4
On Change Event and Intersect 4
VBA - before delete 3
Trying to Close File 1

Back
Top