View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J P Singh J P Singh is offline
external usenet poster
 
Posts: 4
Default Worksheet Change Event Help Please

Hi All

I wish to run a macro on any change in the data in a particular column and
have tried to use the following but the macro doesn't execuate automatically
when I change anything in my worksheet nothing happends and I don't get the
Msgbox.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Msgbox("Macro is running")

End Sub

Any help is greatly appreciated

Thanks

Jas