ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check boxes in Excel: Not moving with cell... (https://www.excelbanter.com/excel-discussion-misc-queries/125707-check-boxes-excel-not-moving-cell.html)

Sistercoo

Check boxes in Excel: Not moving with cell...
 
I have added multiple check boxes into a document, which appear to be working
well (i.e., I can check and uncheck.) The problem is when I go to insert a
row - the check box does not move with the desired cell. I have tried Format
Control/Properties/Object Positioning, but can't seem to get the check box to
stay "assigned" to a given cell.

Any thoughts would be greatly appreciated.

Dave Peterson

Check boxes in Excel: Not moving with cell...
 
Are you sure the checkbox is completely within the cell?

And what type of checkbox did you use -- from the Forms toolbar or from the
Control toolbox toolbar?

And which option did you use: "Move and size with cells" or what?

Sistercoo wrote:

I have added multiple check boxes into a document, which appear to be working
well (i.e., I can check and uncheck.) The problem is when I go to insert a
row - the check box does not move with the desired cell. I have tried Format
Control/Properties/Object Positioning, but can't seem to get the check box to
stay "assigned" to a given cell.

Any thoughts would be greatly appreciated.


--

Dave Peterson

Sistercoo

Check boxes in Excel: Not moving with cell...
 
Dave:

Thanks - just distinguishing between the Forms and Control Toolbar did it
for me. Have now recreated the check boxes using the Control Toolbar and all
seems ready to go.

Thanks!

"Dave Peterson" wrote:

Are you sure the checkbox is completely within the cell?

And what type of checkbox did you use -- from the Forms toolbar or from the
Control toolbox toolbar?

And which option did you use: "Move and size with cells" or what?

Sistercoo wrote:

I have added multiple check boxes into a document, which appear to be working
well (i.e., I can check and uncheck.) The problem is when I go to insert a
row - the check box does not move with the desired cell. I have tried Format
Control/Properties/Object Positioning, but can't seem to get the check box to
stay "assigned" to a given cell.

Any thoughts would be greatly appreciated.


--

Dave Peterson


Dave Peterson

Check boxes in Excel: Not moving with cell...
 
This is just a guess, but I'm wondering if the problem was really with the size
of the checkbox--that it wasn't completely in the cell???

Sistercoo wrote:

Dave:

Thanks - just distinguishing between the Forms and Control Toolbar did it
for me. Have now recreated the check boxes using the Control Toolbar and all
seems ready to go.

Thanks!

"Dave Peterson" wrote:

Are you sure the checkbox is completely within the cell?

And what type of checkbox did you use -- from the Forms toolbar or from the
Control toolbox toolbar?

And which option did you use: "Move and size with cells" or what?

Sistercoo wrote:

I have added multiple check boxes into a document, which appear to be working
well (i.e., I can check and uncheck.) The problem is when I go to insert a
row - the check box does not move with the desired cell. I have tried Format
Control/Properties/Object Positioning, but can't seem to get the check box to
stay "assigned" to a given cell.

Any thoughts would be greatly appreciated.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com