Reusing a list of options on a form

Fantastic, thanks for that

You're welcome. But, I must admit, I was only partly correct. I was reminded today that when the combo box is on a form, you can still tie it directly to a range in the workbook. Instead of being called the ListFillRange, it is called the RowSource. Different name, but acts exactly the same.

So, if you are still reading this thread, try this:

With Me.cmbDivision
    .RowSource = "ListData!A2:A15"
End With