Use of Control Tools

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and the
list. I would like to get into the list to put a value at the top that says
"choose an option" AND have that option show so that people know to click the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy
 
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
 
Back
Top