software

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

www.contextures.com/xlDataVal01.html

moorefun wrote:
gt; I have several columns in a spreadsheet where I would like to use a
gt; combo box for data entry into a cell.
gt; I can make the combo box work if I limit the data into a single cell
gt; repeatidly, but not when I open a cell in the column and want to use
gt; the combo box for the data in that cell.
gt; I am not a VB user, so is there a way using just excel capabilities?
gt;
gt; Thanks
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html