RE: ability to put checkboxes into a cell (not just onto)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

If you enter Design Mode via the Visual Basic Toolbar you can delete
checkboxes. Is this what you were needing to know?

Thanks,
Matt


"jayjay17" wrote:

> It seems that checkboxes can only sit on top of a cell. It would be nice to
> have a real cell-checkbox association. I haven't tried any programming, but
> maybe that'd make event programming easier. What frustrates me most is that
> when I delete cells onto which I've put checkboxes, the checkboxes don't get
> deleted and I can't find a way to delete them manually. The only way to do
> that is to first remove each cell, and then delete the group of cells.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=6917ee3e-bea0-421f-86dc-a8ada5644970&dg=microsoft.public.excel.misc
.

Relevant Pages

  • Re: Copying format controls - xl2003
    ... Select the range that would have held the checkboxes. ... This version uses the cell containing the checkbox as the linked cell. ... Dim iCtr As Long ... Debra Dalgleish has some notes how to implement macros here: ...
    (microsoft.public.excel.misc)
  • Re: Check box and and formula
    ... Those checkboxes are linked to cells B1:B60. ... Biff ... > and then the specifc instructions for that checked box, ... > I have all of the checkboxes linked to a cell as you suggested, ...
    (microsoft.public.excel.misc)
  • Re: associate "pick box"
    ... the Forms toolbar or from the control toolbox toolbar). ... Select the range that would have held the checkboxes. ... Hit the delete key on the keyboard to clear the cell. ... 'I can't see the true/false in the worksheet, ...
    (microsoft.public.excel.misc)
  • Re: associate "pick box"
    ... "Dave Peterson" wrote: ... Select the range that would have held the checkboxes. ... Hit the delete key on the keyboard to clear the cell. ... 'I can't see the true/false in the worksheet, ...
    (microsoft.public.excel.misc)
  • Re: Tick Boxes that are attached to a cell
    ... You can get checkboxes to move with a cell, ... 'This is worksheet event code, which means that it needs to be ... 'placed in the appropriate worksheet code module, ... > into the cell so that when I copy the rows down it copies the tick box. ...
    (microsoft.public.excel)