Third value for a checkbox

[kwd53]

Is it possible to add a third option to a checkbox using app script insertCheckboxes(['☐','☑']); so that a third option might be a box with and x value

[Squeaky]

Hi kwd, When using an active-x checkbox, in the properties look for the property called TripleState. Toggle this to true, and it will give you a third check option. No check, black check, and green check. In the linked cell, the results are true, false, and #n/a.

Squeaky.

[kwd53]

Thanks for the info I will look into it