Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
First question:
One of the tab in my workbook has several checkboxes arranged in a number of columns. One of the set is over the cells, say, A1:A20. I would like to attach these checkboxes to the cell they belong to so that they will have exactly the same size with their cells, and resized along with the cells. Is this possible? Second question: How much overhead does control checkbox has over simply using cell.value = "Y" or "N" ? I just saw an answer to another post concerning toggling a cell between "" and "X". If this works, I could remove all those checkboxes. The solution is to add a block of code to the Worksheet_SelectChange routine. I managed to extend the code to work for multiple cells within the given range. However, this code doesn't seem to work if there are Application.Enables = False/True statements in the routine. Thanks, pac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I setup a cell in Excel as a checkbox w/o a form/activex c. | Excel Discussion (Misc queries) | |||
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |