Hi Kathy
You can not put controls in cells. Controls float above the worksheet and
may or may not connect their results and behavior to the underlying cells.
So you can make something that looks like checkboxes in cells, or cells that
look like ckeckboxes, but it grows messy pretty fast and will be very
awkward to operate from a keyboard.
The dropdown list is Data validation. See
http://www.contextures.com/xlCondFormat01.html on this, it's very useful.
HTH. Best wishes Harald
> Two questions:
>
[quoted text clipped - 10 lines]
> Thanks very much,
> Kathy
Harald Staff - 25 Jan 2005 21:51 GMT
> The dropdown list is Data validation. See
> http://www.contextures.com/xlCondFormat01.html on this, it's very useful.
Apologies for the wrong link, a "copy" action didn't do the job. Should be
http://www.contextures.com/xlDataVal01.html
Harald
Kathy - 26 Jan 2005 01:03 GMT
THANKS VERY MUCH, THIS HIT THE SPOT!
Kathy
> > The dropdown list is Data validation. See
> > http://www.contextures.com/xlCondFormat01.html on this, it's very useful.
[quoted text clipped - 3 lines]
>
> Harald
Harald Staff - 26 Jan 2005 18:59 GMT
Cool, thanks for the feedback!
Best wishes Harald
> THANKS VERY MUCH, THIS HIT THE SPOT!