You code works fine, but must be put in worksheet code.

Right-click any tab
Select view code
Enter your code
--
Gary's Student


"Frank Xia" wrote:

Hi,
I am trying a simple worksheet change event as following:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
MsgBox ("ok")
End sub

but it does not fire and I can not the msgbox shown up. Is there any
condition apply to this event?

Any help appreciated!