P
packat
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
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