When I add a checkbox form to my spreadsheet, it is not part of any cell.
It sits above the spreadsheet and can even overlap the row/column/cell
boundary lines.

When I place them so that they look like they're "within" the cell,
inserting a row will move the cells with text down, but the checkboxes, as
you can guess, stay put.

Is there someway to stitch the checkbox form to the cell contents itself?

THANKS!!!!!!!!!!

--
With knowledge comes sorrow.

If it's a COntrol Toolbox checkbox
R-click, Format Control, Properties tab, under object positioning, 3
choices.
If it's a Forms toolbar checkbox:
R-click, Format Control, Properties tab, under object positioning, 2
choices.
P.

"Thomas G. Marshall" . com
wrote in message ...

When I add a checkbox form to my spreadsheet, it is not part of any cell.
It sits above the spreadsheet and can even overlap the row/column/cell
boundary lines.

When I place them so that they look like they're "within" the cell,
inserting a row will move the cells with text down, but the checkboxes, as
you can guess, stay put.

Is there someway to stitch the checkbox form to the cell contents itself?

THANKS!!!!!!!!!!

--

Dave Peterson coughed up:
First, make sure your checkboxes are within each row (or cell).

Then rightclick on each and select Format control
then Properties tab

There's an option for moving/sizing with cells.

(The checkbox on the Forms toolbar has different options than the
checkbox on the Control toolbox toolbar.)

But the checkboxes are never gonna be attached to a cell. But they
can float over them nicely <bg.



Which is probably best anyway----As long as they obey the obvious cell
movement issues, I'm happy with that.

I'd suggest though that if they were added as text elements then they would
obey center/left/right alignment, etc.... but no matter.


--
"It's easier to be terrified by an enemy you admire."
-Thufir Hawat, Mentat and Master of Assassins to House Atreides

You can use special characters to represent the check box. Using the
wingding font character code 168 for a blank checkbox and character code 254
for a checked checkbox in a cell and then using code to execute based on the
whether the code is either 168 or 254:
rivate Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.ScreenUpdating = False
If ActiveCell.Value = Chr(254) Then
Application.ScreenUpdating = False
ActiveCell.Value = Chr(168)
Application.ScreenUpdating = False
'code goes here
Application.ScreenUpdating = True
Else
Application.ScreenUpdating = False
ActiveCell.Value = Chr(254)
Application.ScreenUpdating = False
'code goes here
Application.ScreenUpdating = True
End If
Application.ScreenUpdating = True

--Gary

"Thomas G. Marshall" wrote:


When I add a checkbox form to my spreadsheet, it is not part of any cell.
It sits above the spreadsheet and can even overlap the row/column/cell
boundary lines.

When I place them so that they look like they're "within" the cell,
inserting a row will move the cells with text down, but the checkboxes, as
you can guess, stay put.

Is there someway to stitch the checkbox form to the cell contents itself?

THANKS!!!!!!!!!!

--
With knowledge comes sorrow.

DOESN'T WORK.

When I insert a row, the rows all lower, but the checkboxes remain!

Line 24 was where I did a row insert, and this is what happened:






P Daulton coughed up:
If it's a COntrol Toolbox checkbox
R-click, Format Control, Properties tab, under object positioning, 3
choices.
If it's a Forms toolbar checkbox:
R-click, Format Control, Properties tab, under object positioning, 2
choices.
P.

"Thomas G. Marshall"
. com wrote in
message ...

When I add a checkbox form to my spreadsheet, it is not part of any
cell. It sits above the spreadsheet and can even overlap the
row/column/cell boundary lines.

When I place them so that they look like they're "within" the cell,
inserting a row will move the cells with text down, but the
checkboxes, as you can guess, stay put.

Is there someway to stitch the checkbox form to the cell contents
itself?

THANKS!!!!!!!!!!

--



--
"Gentlemen, you can't fight in here! This is the War Room!"