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.
comment.qvw 120.2 K
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 ...')