Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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