I did use Global on both used variable's !
Code: Select all
Global oListener As Object
Global oListenerRange As Object
Sub Start_Listener ' this sub is automaticly started on document-open
oListenerRange=thisComponent.sheets(0)
oListener = CreateUnoListener("Listener_","com.sun.star.util.XModifyListener")
oListenerRange.addModifyListener(oListener)
End Sub
Sub Stop_Listener
oListenerRange.removeModifyListener(oListener)
End Sub
Sub Listener_Disposing(oEvent)
End Sub
Sub Listener_Modified(oEvent)
msgbox("Some cell has changed.")
End Sub