Easy Excel /Combo Box Question

[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!!

Thanks a bunch!!

 

[Chance1234]

create a form with your combobox on , then on the worksheet VBA set up an event on the on click to load the form with the combo on.

use the actice cell doobrie for when getting the value from the combo to the sheet.

also set up an if statement to make sure the combo only loads up when they are in the column where it should be