The code for a sheet event is located in, or is called by, a procedure in the code section of the worksheet. Events that apply to the whole workbook are located in the code section of ThisWorkbook.
Events are recursive.
That is, if you use a Change Event and then change the contents of a cell with your code, this will innate another Change Event, and so on, depending on the code. False at the start of your code Application. You should probably use this with the sub above to ensure ' that the user is outside of myRange when the sheet is activated. If you enter Mar-97 in Sheet1, it places the amount for March in ' the cell to the right. True End Sub 'If you select a cell in a column that contains values, the total 'of all the values in the column will show in the statusbar.