Currently I have a book that has a combobox inside a usermodule.

The row source is set to Sheet1!E2:E12

E2:E12 all have values in them...

Let's say I add something to E13.. How can I get the rowsource to automatically include E13 without me having to manually update it every time?