View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank Xia
 
Posts: n/a
Default Event doesn't fire

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!