Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a certain listbox to be defined as Only One selected Value in a specific sheet. I created an alternate state and defined it in that sheet. I also defined the objects as Default State. But still that object is defined as Only One selected Value for the rest of the sheets.
Is there a way to achieve this behavior differently?
Thanks!
Hi,
The object should belong to the different Alternate state then default.
Also you will have to write proper set analysis to make the selection of that alternate state applicable in default state charts and graphs.
Regards,
Kaushik Solanki
Hi Kaushik,
In that sheet I have Year,Month & Day listbox. I use a sheet trigger to define them default values. Only Day should be one selected value. So should I apply your advice to Year & Month too?
Thank you!