Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dear Experts,
I need simulate the option of 'Always one value selected' , if I said simulate is because, if I select that option can't clean in other tab
so somebody have any idea about how can simulate in a list box the same functionallity of 'Always one value selected' option?
Best regards.
Hi Roldan,
There are several options to handle this problem:
Trigger on Tab open to assign certain value to the field while moving to selected Tab
Disregard field selection in Set Analysis (recommended):
Field1=
etc
Hope it will help
I'd say use sheet property triggers to define a variable as the selection, you can then use an input box with constraints to change the selection in the sheet rather than a list box and a clear trigger on leaving the sheet if need be. this will however result in the same variable always being selected on sheet open, it wont be persistent
Just like @boris Gerchikov said, several options, most easy is to create triggers on selected Tab, setAnalysis and third option by macro on selection (do not recommend this last one), but it might help if you want to save the previous selection before entering the Tab which activates the trigger... once you are done, when you return to the original Tab you may restore previous selection.
Cheers!
thanks Thomas ,
where I can configure the constraints of the imput box?.
you mean the variable set with the value of the selection?
best regards.
Hi Boris thanks for answer,
well I do the trigger on tab but when select other value the selection has two values and I need only one.
is any way to do that with out the configuration of 'Always one value selected'?
best regards.
the Set Analysis where a can configurate?.
regards.
Hi,
I tried with lock fields, please have a look at the appln attached.
Hope it helps.
Kiru
Hi Kiruthi, thanks a lot.
well is good the trigger but I mean,
in the first tab, the list box, have to change but, only with one value. and this not affect the second tab.
and with out the 'always one value selected'
best regards.
Hi Roldan,
I think the Alternate State option would be a useful choice. Try it out.
Thanks!