Convert Column of Checked Boxes to TRUE or FALSE

[DaddyH]

Hi Guys,

Looking for a little help please.

I have copied in a table from another source. The table has 500 lines of data. Each line of data contains a Checked box. I need to see which of the checked boxes are TRUE or FALSE. The table only has 4 columns with all checked boxes being in column "D".

Any ideas please?

Your help is greatly appreciated as this is doing my head in

Cheers

 

[cnestg8r]

Each check box must be associated with a cell. Maybe E2 in your case.

To select a check box, press the Ctrl key, and click on the check box
Click in the Formula Bar, and type an equal sign =
Click on the cell that you want to link to, and press Enter

 

[oldbrewer]

is the checked box a font like windigs ?

 

[cnestg8r]

No, it needs to be a form control from the developers tab.

 

[DaddyH]

Each check box must be associated with a cell. Maybe E2 in your case.

To select a check box, press the Ctrl key, and click on the check box
Click in the Formula Bar, and type an equal sign =
Click on the cell that you want to link to, and press Enter

Thanks for your response. When i Press CTRL key i get this formula already in it

=EMBED("Forms.HTML:Checkbox.1","")

What do i replace it with? And is there a way to do all 500 lines in one go?

Thanks

 

[DaddyH]

Hi guys, sorry to chase but i could really do with some help here please.

Any ideas?

Thanks

 

[oldbrewer]

can you see the value of the check boxes ie the true and false words

do you know what drives the value of the check boxes

could you copy again and use paste, special, values

 

[DaddyH]

Thanks for coming back to me.

Unfortunately Copy, Paste Special Values returns blank cells in another column.

I can't see the value of the Check Boxes, just that they are ticked or unticked