Setting up events in Excel

[bhujanga]

I was reading an earlier post and saw that it is apparently possible to attach VBA code to events that occur on a worksheet (such as worksheet change event). I didn't know this was possible - I've always set up command buttons to get these things done. So I'm fishing around now trying to figure out what you do to actually set up this sort of thing and can't find anything. Can someone tell me how to get to these events?
Thank you.

 

[SkipVought]

Hi,

Can someone tell me how to get to these events?

Right-click the Sheet Tab and select View code.

This makes the code window for this sheet visible.

Above the code window are 2 dropdowns. In the LEFT dropdown, select Worksheet. In the RIGHT dropdown select one of the Worksheet events.

Use the Project Explorer to select other Excel Worksheet or ThisWorkbook objects.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]