Page 1 of 1
Executing a macro when a event occurs.
Posted: Tue Apr 29, 2008 3:07 pm
by recarnevale
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???
Re: Executing a macro when a event occurs.
Posted: Tue Apr 29, 2008 3:09 pm
by Villeroy
Re: Executing a macro when a event occurs.
Posted: Tue Apr 29, 2008 3:27 pm
by recarnevale
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.
Re: Executing a macro when a event occurs.
Posted: Tue Apr 29, 2008 3:50 pm
by Villeroy
You can control OOo with Java as well (even better).