[RESOLVED] Worksheet_Change Event

[JJJCR_FOX]

Hi, how to access to the worksheet_change event on my current worksheet?

thanks in advance..i'm using office 2k3

i want to put a code like this:

Private Sub Worksheet_Change(ByVal Target As Range)

'code place in here

End Sub

[Akos_beres]

If you are asking about how to go to the code window.

1. Hit 'Alt F11'
2. On the left hand side, double click on the sheet that you would like to associate the code with
3. There are two drop downs on the new window. One of them (the left one) will say '(General)' the other (on the right) will say '(Declaration)'. Change the one on the left from 'General' to 'Worksheet'.

Hope this helps good luck

[JJJCR_FOX]

thanks Akos for the response..but it's not the one...i want to know where to place the code in post #1..

the General option on the left I can't find the worksheet option nor change it to worksheet also...

[Siddharth Rout]

See the picture and follow these steps

1) Double Click the Worksheet to access the code area.
2) Select 'Worksheet' instead of 'General'
3) Select the 'Change' event after that
4) Place your code

Hope this is what you wanted?

[JJJCR_FOX]

thanks Koolsid, thanks Akos...yup..probem solved... there's another way to do it also..right click the name of the worksheet ("sheet1") then choose "view code"

[Siddharth Rout]

No offense meant but giving you that shortcut was the next step. You need to first understand the basics of it....

You got a shortcut in post 2 but it didn't help and hence those snapshots in post 4.

Glad it is resolved