Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ability to put checkboxes into a cell (not just onto)
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |