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" <(E-Mail Removed)>
wrote in message news:OaiC2%(E-Mail Removed)...
>
> 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!!!!!!!!!!
>
> --
>
>

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.
>
>
>