[FAQ000140]How to change the selection of a list (LIST function) in an action?

Q

I want to change the value selected in a list (LIST function) by an action,

but when I set the value in the cell containing the list, the LIST function in the cell disappears

and only the value is contained.

Is it possible to change the selected value of a list (LIST function) in an action?

A

It is possible to change the selected value of a list (LIST function) with an action.

The reason why the LIST function written in the cell disappeared and the value was set is that

you may have set a value that is not a candidate for selection in the list.

When setting a value in a list (LIST function), if the choice contains the corresponding value,

the selection in the list (LIST function) will be changed;

if the choice does not contain the corresponding value, the list (LIST function) will be canceled

and only the value will be set in the cell.

For example, suppose we have the following list (LIST function) in a cell.

・"=LIST(1,"CELF","RPA","SCSK")"

If you set "RPA" to a cell in the action,

the list will have "RPA" selected.

However, if you set "ABC" which is not one of the selections in the list,

the LIST function in the cell will be rewritten as "ABC" and the list will disappear.