I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire ce

[Leonid L]

.... So that, a click anywhere within the cell should trigger the
checkbox. I was not able to do that because the checkbox is always
placed right next to the left side of it's clickable area. If only I
could change that alignment to "middle" somehow, all my problems would
go away.

Eventually I want to do this programmatically, but manual steps are
also welcome, as I can just record a macro. This has to work in
Excel2003, so I want to use the simplest type of checkboxes available.

Many thanks.

 

[FSt1]

hi
not sure why you need it in the middle but if you just want it to show and
click in the "cell"...just leave out the captions. size the checkbox to the
size of the cell, not caption, set background to transparent. that way all
you would see is the checkable box and clicking anywhere in the "cell" would
be clicking the checkbox control not just the small checkable box and set the
checkbox control to true or false.
not what you wanted but maybe a work around????

regards
FSt1

 

[Leonid L]

Thanks for the input. If I undersyood you correctly, then what you
described gets half of the job done.
However, alignment within the cell is still a problem. When you place
text inside of the cell, it's horizontal "anchor" (for the lack of
better term) can be: left, center, right. Same goes for the vertical
alignment. This is quite handy. A checkbox cannot have any of the 9
possible anchors (top-left, center-center, top-right, etc.). The only
anchor it gets (within its area) is left-center. I really wish there
was a way to place it in the center-center, so that it is properly
aligned with the corresponding header of a table.

If it is possible to link two checkboxes to the same cell (but make it
look like there is only one), then I would do it. I don't mind writing
some crazy VBA to achieve the desired appearance (if only it is
possible at all).

I hope I made it clearer what I am trying to achieve. I was deleting
the caption previously, but it is possible that I am missing
something.

Thanks