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

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

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

moorefun wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html