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

[jayjay17]

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/comm...lic.excel.misc

[Matt Lunn]

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/comm...lic.excel.misc

[jayjay17]

Hi,
Thanks for your answer, Matt.
My environment is not fully set, I don't know if I can test that. I'm just
an occasional excel user and I've actually never done that kind of
programming (VBA). I thought (hoped) maybe the cells could be used the way
forms (in the GUI sense) are, but I guess that'd be pushing Excel a bit too
far; in that sense, Excel would be a kind of VB (then you could access
checkbox1 as cell1A.checkbox1, and do things such as
cell1A.checkbox1.isChecked for example), a spreadsheet would be a big
collection of forms, seems unmanageable to me.
What do you think?
Jerome

"Matt Lunn" wrote:

> 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

[Matt Lunn]

Don't know how possible that would be but it would certainly be useful for
the issue you have raised. You can link the values of some of the controls
with cells, for example a Listbox can be associated with a range of cells to
display it's options and another cell to hold the value of a choice. In the
main, the association of a control is with the worksheet.

Cheers,
Matt

"jayjay17" wrote:

> Hi,
> Thanks for your answer, Matt.
> My environment is not fully set, I don't know if I can test that. I'm just
> an occasional excel user and I've actually never done that kind of
> programming (VBA). I thought (hoped) maybe the cells could be used the way
> forms (in the GUI sense) are, but I guess that'd be pushing Excel a bit too
> far; in that sense, Excel would be a kind of VB (then you could access
> checkbox1 as cell1A.checkbox1, and do things such as
> cell1A.checkbox1.isChecked for example), a spreadsheet would be a big
> collection of forms, seems unmanageable to me.
> What do you think?
> Jerome
>
> "Matt Lunn" wrote:
>
> > 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