Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
If I have a list box and use it as check box is it possible to keep a specific value always checked even if one press clear?
I would like to keep "Total" in my list box even if you click clear.
Many thanks in advance for your help.
Best regards,
Carolin
Hi Carolin,
First you select Total from your list box and then click on Set Clear state option.
After that you can select other options also in list box and then click on clear. It will clear all other except the first one which you selected before click on Set Clear Set.
And also in Sheet properties add one trigger Select in Field for selecting specific option what you want.
Go to list box properties and select 'Always one vale select ' check box.
Find screenshot for more clarification.
Hi Carolin,
You can use following Action/Triggers to achieve this:
Action Type: Selection
Action : Select In field
then give the field name and value you want to get selected.
Once done, add another Action as :
Action Type: Selection
Action : Lock Field
and add the name of the field in which you wnat the selections not to be cleared.
You can use these Actions/Triggers on any event per your requirements.
Hope this helps!
Open the Link from enclosed file.
This is what you want..
Hi jsingh71.
If I choose Always one value select you cant select all data of the list box.
I think you should go for trigger.
Unfortuntely this doesn´t work as it is not highlighted. You cannot choose this maybe because its a LED check box.
Hi Carolin,
It will be highlighted only when first you have selected a value.
Hi Shyamal,
I think it will lock the field value and won't allows any other selections in the same field.
Thansk, Pradeep
Hi Pradeep,
Yes, you are right. My bad 😞
Carolin Borchert : You can just give "Select In field" action on various events and skip "Lock field".