Combo Box range where user adds items to a worksheet and they are added to combo box

[gilly01625]

Hey,

I have a userform with a Combo Box that is populated with options from a worksheet. Next to the Combo Box is a button which allows the user to add a new item to the combo box - the item is added to the same worksheet.

How do I include all new items added to the worksheet to the combo box without defining a large range which would include all the empty values.

Thanks

First image in the combo box and button, second is the form that opens once the button is pressed, and third is the worksheet where the information is stored

 

[Micron]

Perhaps one of the methods listed here?

Using dynamic ranges to populate combobox

I have a combobox in a userform which takes its values form a dynamic range using this formula =OFFSET($A$1,0,0,COUNT($A:$A),1) This works ok but I want to add rows with new data at the start of this list, and include this new data in the combobox. When I do this though it corrupts the...

www.mrexcel.com

 

[gilly01625]

Perhaps one of the methods listed here?

Using dynamic ranges to populate combobox

I have a combobox in a userform which takes its values form a dynamic range using this formula =OFFSET($A$1,0,0,COUNT($A:$A),1) This works ok but I want to add rows with new data at the start of this list, and include this new data in the combobox. When I do this though it corrupts the...

www.mrexcel.com

That's perfect, thank you so much!

 

[Micron]

You're welcome, but the real one to thank is Google.