Excel - VBA combo box

[Candles]

Hi, I want to add some combo boxes to a spreadsheet so that a user can either select a value from the box or enter a new one. I'm not quite sure how to do this.

If I have 5 columns and infinite rows, does this mean that I have to have a combo box in every cell or is there a way that I can just have 1 combo box for each column and place the value selected into the next empty row??

Please help!! I don't want to have to use a form.

Thanks a bunch!!

 

[RobBroekhuis]

I guess you could try to use the worksheet_selectionchange event to dynamically generate a combobox for any cell the user selects. It would work, but may be unacceptably slow.
If you need more pointers on how to accomplish such a thing, follow up here.
Rob