View Single Post
  #2   Report Post  
 
Posts: n/a
Default

controls like check boxes and combo boxes cannot be
assigned to cells. they sit on top of the sheet. to get
them on the sheet simple click the icon on the tool bar
then click a place on the sheet and drag right and down.
the contol's "size" depend on how much you drag.
once on the sheet, right click the control. click and set
properties. you may also assign code.

-----Original Message-----
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
.