Executing a macro when a event occurs.

recarnevale · Post by **recarnevale** » Tue Apr 29, 2008 3:07 pm

Hi, I need to activate, or execute, a macro written in Basic that changes something in a spreadsheet when a particular event occurs. For example, this macro should change the background color of a cell when the value of this one chage. How can I captire this event in Basic???

edit this topic's initial post · Post by **Villeroy** » Tue Apr 29, 2008 3:09 pm

Why not using conditional formatting or function STYLE()?
http://user.services.openoffice.org/en/ ... php?id=667
http://user.services.openoffice.org/en/ ... php?id=716

recarnevale · Post by **recarnevale** » Tue Apr 29, 2008 3:27 pm

No mine is a generic consideration, my script has to intercept an event such as chaging value and make something. In another forum someone told about listeners. I'm a java programmer, i know listeners but in Basic I've no idea.

edit this topic's initial post · Post by **Villeroy** » Tue Apr 29, 2008 3:50 pm

You can control OOo with Java as well (even better).

Executing a macro when a event occurs.

Executing a macro when a event occurs.

Re: Executing a macro when a event occurs.

Re: Executing a macro when a event occurs.

Re: Executing a macro when a event occurs.