software

I was sent an excel book and there 10 columns, 15 rows of checkbox
data. In each of these cells there are mutiple check boxes. How in the
WORLD do I extract out the information out of the data? I did not build
the workbook and there is not any code to tell me what's going on
etc...
I have never messed with checkbxes only validation lists and am totally
at a loss!

Any help is MOST GRACIOUSLY Needed!Thanks,

HansI just found out about those too. I was trying to cancel out a column of
numbers when checked.
They link to a cell and evaluate at true/false (1 or 0). I just multiplied
the column total by the linked cell and that either left the value alone or
zeroed it.
Right click on them select quot;format controlquot; and see where they point. That
might help you.

gt; wrote in message oups.com...
gt;I was sent an excel book and there 10 columns, 15 rows of checkbox
gt; data. In each of these cells there are mutiple check boxes. How in the
gt; WORLD do I extract out the information out of the data? I did not build
gt; the workbook and there is not any code to tell me what's going on
gt; etc...
gt; I have never messed with checkbxes only validation lists and am totally
gt; at a loss!
gt;
gt; Any help is MOST GRACIOUSLY Needed!
gt;
gt;
gt; Thanks,
gt;
gt; Hans
gt;
Well here is the secondary problem, if I right click the actual box,
there is nothing. If I rightclick the cell, there is nothing. When I
created a checkbox of my own on this sheet, it will show exactly what
you are saying...This is bewildering! It is like the cells amp; worksheet
is protected, but it is not. So, how do I go about extracting the
information, without being able to reference the checkbox!?! As Charlie
Brown would say, quot;ARRRGGGHHH!!quot;

I appreciate any further insight you may have

Thanks,

HansOkay...got a little further since a few moinutes ago. I can access the
check box/format control..it only has the Size, Protection, Properties,
Web tabs only. Now in the formula bar it has the following:
=Embed(quot;Forms.Checkbox.1quot;,quot;quot;). Does this give you any insight as to how
they designed this??

HansSee if this gets you on the right track....

A Checkbox can be linked to a cell that will reflect the value of the
Checkbox.
You can determine which cell is linked by:

If the Checkbox came from the Forms Toolbar:
Right-click on the Checkbox
Select: Format Control
Select the Control tab
The linked cell will be contained in the Cell Link box.

If the Checkbox came from the Controls Toolbar:
Display that toolbar
Click the Design Mode icon (so the Checkbox can be selected)
Right-click on the Checkbox
Select: Properties
The linked cell will be contained in the LinkedCell field.

Hopefully, the other checkboxes will be assigned to cells in that general
area too.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot; wrote:

gt; I was sent an excel book and there 10 columns, 15 rows of checkbox
gt; data. In each of these cells there are mutiple check boxes. How in the
gt; WORLD do I extract out the information out of the data? I did not build
gt; the workbook and there is not any code to tell me what's going on
gt; etc...
gt; I have never messed with checkbxes only validation lists and am totally
gt; at a loss!
gt;
gt; Any help is MOST GRACIOUSLY Needed!
gt;
gt;
gt; Thanks,
gt;
gt; Hans
gt;
gt;

Seeing quot;=Embed(quot;Forms.Checkbox.1quot;,quot;quot;)quot; in the formula bar indicates that the
control came from the Controls toolbar. Consequently, when in Design Mode
you can:

Right-click on the Checkbox
Select properties
View the contents of the LinkedCell field

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot; wrote:

gt; Okay...got a little further since a few moinutes ago. I can access the
gt; check box/format control..it only has the Size, Protection, Properties,
gt; Web tabs only. Now in the formula bar it has the following:
gt; =Embed(quot;Forms.Checkbox.1quot;,quot;quot;). Does this give you any insight as to how
gt; they designed this??
gt;
gt; Hans
gt;
gt;