Loading a list onto Combo box ActiveX Control RRS feed

  • Question

  • Hello, 

    I would like to know if there is any way that I can add a list on to the combo box in a worksheet. Since the list is dynamic linking the fill range has not been helpful. Every article I read about my problem is related to combo box in a user form. In my case the combo box is on a worksheet. Any help will be much appreciated. Thanks!

    Thursday, May 9, 2019 8:45 PM

All replies

  • One option is to create a one-column table that contains the list items.

    Set the ListFillRange of the combo box to the address of the data body of the table (i.e. the table without its header cell). This doesn't look dynamic, but Excel will automatically adjust the ListFillRange when you add or remove items.

    Regards, Hans Vogelaar (

    Thursday, May 9, 2019 9:18 PM