Thank you very much! It helped!
"Chip Pearson" wrote:
Frank,
Is the code in the ThisWorkbook code module? It must be in that
module, not a regular code module, for the code to work. Also,
ensure that Application.EnableEvents is True. In the VBA Editor,
press CTRL+G to display the Immediate window, and type the
following and press Enter
Application.EnableEvents = True
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Frank Xia" wrote in message
...
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!