Combo Boxes for data entry

[moorefun]

I have several columns in a spreadsheet where I would like to use a
combo box for data entry into a cell.
I can make the combo box work if I limit the data into a single cell
repeatidly, but not when I open a cell in the column and want to use
the combo box for the data in that cell.
I am not a VB user, so is there a way using just excel capabilities?

Thanks

 

[Debra Dalgleish]

Instead of a combo box, you could use data validation. There are
instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html