If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

I used a checkbox from the Forms toolbar (not from the Control toolbox toolbar)
and copied a range of cells that included a checkbox named "Check Box 2".

When I pasted into a new sheet, that checkbox was named "Check Box 1".

I used xl2003 to test.

If you use a different version of excel or you used checkboxes from the control
toolbox toolbar, you can do the same sort of thing to test.

You can use a macro to count the "checkedness" of any set of checkboxes--but the
code would be different for each type.

And you can rename the checkboxes by selecting them and typing the new name into
the namebox (to the left of the Formula bar).

If you used checkboxes from the control toolbox toolbar, you'll have to be in
design mode (another icon on the control toolbox toolbar in xl2003 menus)--an
icon on the developer's tab on the ribbon in xl2007.

Robin wrote:

If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

--

Dave Peterson

Dave,

I used the developer tab and selected from the form controls. I then
selected check box and renamed it. ( I did this multiple times so that there
are multiple renamed checkboxs). I then copied the work sheet to another work
sheet. I am trying to understand your instructions but you are more advanced
that I am. The checkbox was used to gather data. Is there a way to determine
how may of the same check boxs are checked and how do you check on this?Do
you type in the name of the checkbox or what?I have excel 2007 but can
convert to 97-2003. What do I need to do? I appreciate your help form you
have helped me before.

Robin

"Dave Peterson" wrote:

I used a checkbox from the Forms toolbar (not from the Control toolbox toolbar)
and copied a range of cells that included a checkbox named "Check Box 2".

When I pasted into a new sheet, that checkbox was named "Check Box 1".

I used xl2003 to test.

If you use a different version of excel or you used checkboxes from the control
toolbox toolbar, you can do the same sort of thing to test.

You can use a macro to count the "checkedness" of any set of checkboxes--but the
code would be different for each type.

And you can rename the checkboxes by selecting them and typing the new name into
the namebox (to the left of the Formula bar).

If you used checkboxes from the control toolbox toolbar, you'll have to be in
design mode (another icon on the control toolbox toolbar in xl2003 menus)--an
icon on the developer's tab on the ribbon in xl2007.

Robin wrote:

If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

--

Dave Peterson

I don't understand.

Are you copying the entire sheet (like rightclicking on the sheet tab and
choosing move or copy) or are you copying a range of cells that include
checkboxes?

And I'm not sure what you're trying to do with the checkboxes.

I think you're going to have to add some more details.

Robin wrote:

Dave,

I used the developer tab and selected from the form controls. I then
selected check box and renamed it. ( I did this multiple times so that there
are multiple renamed checkboxs). I then copied the work sheet to another work
sheet. I am trying to understand your instructions but you are more advanced
that I am. The checkbox was used to gather data. Is there a way to determine
how may of the same check boxs are checked and how do you check on this?Do
you type in the name of the checkbox or what?I have excel 2007 but can
convert to 97-2003. What do I need to do? I appreciate your help form you
have helped me before.

Robin

"Dave Peterson" wrote:

I used a checkbox from the Forms toolbar (not from the Control toolbox toolbar)
and copied a range of cells that included a checkbox named "Check Box 2".

When I pasted into a new sheet, that checkbox was named "Check Box 1".

I used xl2003 to test.

If you use a different version of excel or you used checkboxes from the control
toolbox toolbar, you can do the same sort of thing to test.

You can use a macro to count the "checkedness" of any set of checkboxes--but the
code would be different for each type.

And you can rename the checkboxes by selecting them and typing the new name into
the namebox (to the left of the Formula bar).

If you used checkboxes from the control toolbox toolbar, you'll have to be in
design mode (another icon on the control toolbox toolbar in xl2003 menus)--an
icon on the developer's tab on the ribbon in xl2007.

Robin wrote:

If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

--

Dave Peterson


--

Dave Peterson

Dave,

I am trying to understand after the cell with the varying named checkboxs
are copied from say A5 on a worksheet to the A5 on another worksheet can be
checked somehow to see how many of the same named checkbox have been checked.
Say if there were 50 worksheets and the check box had been checked on a
certain number of them is there a way to determine without counting them how
many of the same named check boxs have been checked. Also I have created a
specific spread sheet with mathematical data that I would like to build a
database and am looking for someone to do it. Where can I find a person to do
this?

Sincerely,

Robin

"Dave Peterson" wrote:

I don't understand.

Are you copying the entire sheet (like rightclicking on the sheet tab and
choosing move or copy) or are you copying a range of cells that include
checkboxes?

And I'm not sure what you're trying to do with the checkboxes.

I think you're going to have to add some more details.

Robin wrote:

Dave,

I used the developer tab and selected from the form controls. I then
selected check box and renamed it. ( I did this multiple times so that there
are multiple renamed checkboxs). I then copied the work sheet to another work
sheet. I am trying to understand your instructions but you are more advanced
that I am. The checkbox was used to gather data. Is there a way to determine
how may of the same check boxs are checked and how do you check on this?Do
you type in the name of the checkbox or what?I have excel 2007 but can
convert to 97-2003. What do I need to do? I appreciate your help form you
have helped me before.

Robin

"Dave Peterson" wrote:

I used a checkbox from the Forms toolbar (not from the Control toolbox toolbar)
and copied a range of cells that included a checkbox named "Check Box 2".

When I pasted into a new sheet, that checkbox was named "Check Box 1".

I used xl2003 to test.

If you use a different version of excel or you used checkboxes from the control
toolbox toolbar, you can do the same sort of thing to test.

You can use a macro to count the "checkedness" of any set of checkboxes--but the
code would be different for each type.

And you can rename the checkboxes by selecting them and typing the new name into
the namebox (to the left of the Formula bar).

If you used checkboxes from the control toolbox toolbar, you'll have to be in
design mode (another icon on the control toolbox toolbar in xl2003 menus)--an
icon on the developer's tab on the ribbon in xl2007.

Robin wrote:

If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

--

Dave Peterson


--

Dave Peterson

I don't know of any way of determining the number of checkboxes that are checked
except to count them. And I still don't understand what you are really working
with.

And maybe someone will read this thread and offer some help.

Robin wrote:

Dave,

I am trying to understand after the cell with the varying named checkboxs
are copied from say A5 on a worksheet to the A5 on another worksheet can be
checked somehow to see how many of the same named checkbox have been checked.
Say if there were 50 worksheets and the check box had been checked on a
certain number of them is there a way to determine without counting them how
many of the same named check boxs have been checked. Also I have created a
specific spread sheet with mathematical data that I would like to build a
database and am looking for someone to do it. Where can I find a person to do
this?

Sincerely,

Robin

"Dave Peterson" wrote:

I don't understand.

Are you copying the entire sheet (like rightclicking on the sheet tab and
choosing move or copy) or are you copying a range of cells that include
checkboxes?

And I'm not sure what you're trying to do with the checkboxes.

I think you're going to have to add some more details.

Robin wrote:

Dave,

I used the developer tab and selected from the form controls. I then
selected check box and renamed it. ( I did this multiple times so that there
are multiple renamed checkboxs). I then copied the work sheet to another work
sheet. I am trying to understand your instructions but you are more advanced
that I am. The checkbox was used to gather data. Is there a way to determine
how may of the same check boxs are checked and how do you check on this?Do
you type in the name of the checkbox or what?I have excel 2007 but can
convert to 97-2003. What do I need to do? I appreciate your help form you
have helped me before.

Robin

"Dave Peterson" wrote:

I used a checkbox from the Forms toolbar (not from the Control toolbox toolbar)
and copied a range of cells that included a checkbox named "Check Box 2".

When I pasted into a new sheet, that checkbox was named "Check Box 1".

I used xl2003 to test.

If you use a different version of excel or you used checkboxes from the control
toolbox toolbar, you can do the same sort of thing to test.

You can use a macro to count the "checkedness" of any set of checkboxes--but the
code would be different for each type.

And you can rename the checkboxes by selecting them and typing the new name into
the namebox (to the left of the Formula bar).

If you used checkboxes from the control toolbox toolbar, you'll have to be in
design mode (another icon on the control toolbox toolbar in xl2003 menus)--an
icon on the developer's tab on the ribbon in xl2007.

Robin wrote:

If there are multiple worksheets in a workbook, and within a certain cell
there is a checkbox? If the cell with the check box is copied to another
worksheet, is the checkbox the same number? If the checkbox is the same
number is there a way to show the number of checkboxs with that number that
are checked verses unchecked?

Sincerely,

Robin

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson