Macro to display details(textobject) on the activation of chart(sheetobject)

[kalyandg]

Hi all,

I have to write a macro for five chart(objects), on activation of the object(on selection), it must display a text object which describes about the chart.

I have tried it by using the variable, but presentation will not be nice, when it displays text object for all chart.

so i used to write a macro...

can anyone please help me?

thanks in advance,

kalyan

[sushil353]

We can show the desire operation using button..

i couldn't found a way to trigger a macro when an object is activated.

Please find the attached sample file

Hope that helps you.

Sushil

[marcus_sommer · Accepted solution]

You can use it without macro, only per activate the object.

Set in Sheet/Properties/Trigger a activate and deactivate trigger to the object, which set two variables:

varVisible = 'on' // 'off'

varObject = 'CH01'

varVisible is the visible-condition for the textbox (Properties/Layout) and the content is a formula like this:

= pick(match('$(varObject)', 'CH01', 'CH02'),

                                      'first ...', 'second ...')

- Marcus