resize control checkbox with cell
 

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

Hi
1. Question: AFAIK this is not possible
2. Question: Post the code you've tried which does not work for you.
verhead: Not really sure but as a guess I'd think the Y/N solution does not
use that much memory

"packat" wrote:

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

Frank,
I have a second look and fuixed the problem I had after some
cleaning up. I replaced the checkboxes witht eh toggled
cells, but have a second thought.

The toggle cells may be a bit too sensitive to use comparing
to checkboxes. I can imagine users could highlight a bolck
of cells overlapping with these toggle cells and
intentionally reset the selections.

So I will stick to the checkboxes for now since i haven't
yet encountered any problem with memory.

Thanks
pac






Frank Kabel wrote:
Hi
1. Question: AFAIK this is not possible
2. Question: Post the code you've tried which does not
work for you.
verhead: Not really sure but as a guess I'd think the
Y/N
solution does not use that much memory

"packat" wrote:

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