Checkbox with check/uncheck set dynamically

[Former Member]

Hi all,

I have a check box with default source data 0,1 and it is inserting into the cell $B$1. The issue I have is that I want to control the opening state of the checkbox based on data read in. I can probably do this by overlaying 2 checkboxes and only displaying one based on the opening value. However, I was wondering if anyone had come up with an alternate approach.

Regards

Alan

[Former Member]

Hi Alan

If your looking at the dynamic visibility of the checkboxes based on the data load, can't you set the value of $B$1 based on the dataload instead?

[Former Member]

Hi Charles,

I am not sure if it will work, there might be a circular reference. Ideally I would like to do it without having 2 checkbox components.

Regards

Alan

[Former Member]

Think you'll have to use two checkboxes. How about using a radio button component? At least you can set it's initial state from a cell reference.

Edit: Thought of an alternative way of showing a tick like mark, use the Character Map to find the square root symbol in the Verdana font (Webdings/Wingdings won't really work for this). Paste this into a formula in the spreadsheet something like, =If(<dataloadfinished logic>,u221A,""), and reference this formula from a label and format as appropriate.