[Solved] Change properties of Calc Push Button using macro

[Nocton]

On sheet named 'Sheet1', I have a Push Button named 'Switch' with Label 'ON' and font colour green. After the button's action is executed I want to change it to 'OFF' and Red.
What is the best way to do that?

[Zizi64]

Here is a sample file with an embedded macro.

ButtonProperties.ods

(10.14 KiB) Downloaded 551 times

Modified sample: I just deleted two helper Print commands.

[Nocton]

Thank you Zizi64 - a nice solution.

[qqaazz8]

Here is a sample file with an embedded macro.

ButtonProperties.ods

Modified sample: I just deleted two helper Print commands.

What is the code for "Additional information" ?

[karolus]

What is the code for "Additional information" ?

Code: Select all

msgbox oButton.Tag

[Zizi64]

Use one of excellent object inspection tools: MRI and XrayTool

Usage of them - inside the macro code - will list all existing properties and methods (and others) of the programming objects:

Code: Select all

xray oButton

mri oButton

[qqaazz8]

What is the code for "Additional information" ?

Code: Select all

msgbox oButton.Tag

Thanks.