Populating an ActiveX combobox from a dynamic list

Hey guys!

I would like to create a user-friendly program that permits the user to choose an option from a combobox.

The combobox (on sheet1) should be populated from column A on sheet2, minus the title. I already named a range for column A with an offset so it doesn't include the title. However, when I use ListFillRange in the properties, there are three blanks at the bottom. Also, when I try adding items to my list, the maximum items I can add is three.

Does anyone know any solutions for this?!

Thanks!

Here is one option:

Please Login or Register  to view this content.

Here is one option:

Please Login or Register  to view this content.