Mandatory Multi Select list box

[Anonymous]

Hi Gurus..is there any to make a list box is mandatory for at least one value instead of always one selected value..so that i can facilitate more than one value can be selected or minimum one value has to be selected.

Example: I have Month list box, my requirement is users must select atleast one value in Month and also they should be able to select multiple months.

Please share some workarounds.

Br,

Chinna

[Anil_Babu_Samineni]

There is no prerequisite to check the box. If possible try to enable LED. Image for ref from presentation tab?

[Anonymous]

Hi Anil,

By making the representation as checkbox won't help , If I wanted to do multiselect when I enable Always one selected value checkbox.

Br,

Chinna

[Anil_Babu_Samineni]

there is no default option to achieve this? And i would also recommend to read this How to clear the Always One selected value (Mainly Macro)

[neha_shirsath]

Hi Chinna,

By using Always one selected value you won't achieve multiple selection if you want to avoid using macro.

You can do unchecked Always one selected value and write trigger on Active sheet select current month by default.

then you can select multiple month also and by default you will get one month selection.

Thanks,

Neha

[Anonymous]

Dear Neha,

Above one is already in place. however, our page has clear all button . And some times users are clicking on clear all is clearing the month selection. So I have put additional action on top clear all to select current month.

Now only problem is when they double click on selected month it is getting cleared.

Br,

Chinna

[neha_shirsath]

Hi,

For clear all if you have created Clear all button then in Action don't add Clear all action rather than add Clear Other fields and and give Month field then Other than Month field all field will be clear.

Find the attached file for your reference.

Thanks.