Maybe you can use Data|Validation.
See Debra Dalgleish's site for lots of tips:
http://contextures.com/xlDataVal01.html
art wrote:
I want to add a combe box to a whole chart, each line should have a combo
box. How can I insert in the cell the combo box? I have a long list and I
need in each cell a combo box. It doesn't make sense to make in each cell
seperatly a combo. Isn't there an easier way?
Also how can I make, that after i pick an item from the combo box and press
enter, it should go to the next cell?
Please help.
--
Dave Peterson