[FAQ000112]Can I dynamically set the calendar and check buttons to a desired location?¶
Q¶
Is it possible to dynamically set controls such as calendars, check buttons, etc. to any locations?
For example, when I get a list from a table and display it on a sheet,
how do I set a list for each row?
A¶
There is a way to dynamically set the function to display the control by using the "Set [ ] to cell [ ]" action.
To set an expression (function) in an action, enclose the expression (function) in "="" and """.
The string in the expression is further enclosed in " ".
For example, in cell column A, "=LIST(1,"Item1","Item2","Item3")"to be set dynamically, the action would be as follows.
Set [="=LIST(1,""Item1"",""Item2"",""Item3"")"] to cell ["A"&A1]
Also, here is a good reference.
Related keywords¶
Placement